Hi All,
I have three tables in my SQL Server DB. I need to import some CSV files into these tables.
First table is a Order Table, which will contain all the order level information from that customer in that CSV File.
Each order has multiple items and the second table is an item level data.
Third table is a mapping table which says for a Customer say A ,
field 1 of Order Table = field 3 of Customer's CSV file,
Field 2 of Item Level Table is field 4 of Customer's CSV
and so on..
I need to create an application which takes a csv file and goes to the mapping table and checks what are the customer's field names and map with the order level table and item level tables and put all the data in the respective fields.
Please suggest how to proceed with this using VB.NET . I am very new with VB.Net any help appreciated.
I have three tables in my SQL Server DB. I need to import some CSV files into these tables.
First table is a Order Table, which will contain all the order level information from that customer in that CSV File.
Each order has multiple items and the second table is an item level data.
Third table is a mapping table which says for a Customer say A ,
field 1 of Order Table = field 3 of Customer's CSV file,
Field 2 of Item Level Table is field 4 of Customer's CSV
and so on..
I need to create an application which takes a csv file and goes to the mapping table and checks what are the customer's field names and map with the order level table and item level tables and put all the data in the respective fields.
Please suggest how to proceed with this using VB.NET . I am very new with VB.Net any help appreciated.