By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,560 Members | 1,541 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,560 IT Pros & Developers. It's quick & easy.

Excel to SQL

P: 102
On a scale of 1-10 (1 low and 10 high) my Excel rating would be 3 and my rating a 6.

I have an excel file (exert attached). It was created by exporting data from a Sharepoint list into Excel. I want to read the Excel and put this is in two SQL Server tables. Here's the catch, the Excel is one record and I want to write it in two separate SQL tables (parent - child relationship).

RefNum - Requestor make up the parent
Line# - FreightIvoice make up the child - in this case 4 children

So there would be one entry in the parent table and 4 entries in the child table.

I have imported the Excel file in a DataGridView and I get Line# - 1234, Add/Change - AddAddAddAdd and so forth.

What is going on and is there a better way?

Attached Files
File Type: xlsx Book1.xlsx (16.0 KB, 97 views)
Feb 19 '18 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.