how to upload excel into multiple tables in sql

Question

0.00/5 (No votes)

See more:

I have an excel sheet with 10 columns.

i want this to be imported into sql via 3 tables.

table1
table2
table3

table1 will have 4 columns and fkey from table2 and table3.
table2 will have 8 columns
table3 will have 8 columns.

how to accomplish this using the importdata under database tasks?.

Please help.
Thanks

Posted 15-Aug-14 23:23pm

Member 10562713

Add a Solution

2 solutions

Solution 2

You may create a plain table in SQL Server and import Excel data into it.

Then you may execute SQL code to create normalized data in your tables.

Try the SaveToDB add-in for Excel[^].
It allows saving data into database tables from Excel. It is free.

If you need to repeat this task periodically, you may customize saving data in add-in using stored procedures. It is the same task you need. But this is an Enterprise edition feature.

Posted 16-Aug-14 23:07pm

Sergey Vaselenko

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sl8b · Accepted Answer · 2014-08-16T12:24:00

Solution 1

Are the tables staying in excel, and you want SQL to read from the workbook? If you have already created the database in management studio, you could save each table as a .csv file and upload that way. If you can clarify, I can help you.

Also, what version of SQL and Excel are you using?

Posted 16-Aug-14 12:24pm

sl8b

Comments

Member 10562713 16-Aug-14 18:33pm

I have a single excel sheet with 20 columns or so.
I have three tables created in sql- one with 4columns 2 fkey columns,two other tables with 8 columns.