Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LearningSQL2
Starting Member
10 Posts |
 Posted - 2011-07-20 : 12:24:27
|
| Hello,I am trying to find out how to import several Excel Spreadsheets into an SQL database. I've read about how to import SQL data into Excel, but not the other way around. I'd appreciate any advice you can give. Thank you in advance. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-20 : 14:02:44
|
| One time, or on a recurring basis?For one time, I'll usually save it as a tab delimited text file and bulk insert it.Or you can use the data import wizard.If it's recurring, create an SSIS package and schedule it as a SQL Agent Job. You can use the data import wizard and save the package it creates as well. |
 |
|
|
LearningSQL2
Starting Member
10 Posts |
Posted - 2011-07-20 : 18:16:49
|
| Hi Russell,I am trying to insert an Excel spreadsheet that contains a customer database with thousands of entries into SQL, and then I would like to try to set up a connection between the Excel file and the SQL database so that it is updated when the Excel file is. Unless there is a way to automatically insert all of the commas needed between the data when it transfers from Excel to SQL, then creating an SSIS package seems like a better option. Forgive me for being so new to Denali, but would you mind walking me through how to create an SSIS package or refering me to a link that does? Thanks again,-M.T.D. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-20 : 20:55:38
|
| One easy way is to use the data import wizard, and save the SSIS package it generates. Then you can inspect it to see what it's doing. |
|
|
|
LearningSQL2
Starting Member
10 Posts |
Posted - 2011-07-28 : 11:15:50
|
| Russel,Thak you for your help. Now I've gotten SQL to accept the database. My next step is to rig up an SQL database that shares a continuious link with the excel customer database sheet so that the SQL database is triggered to automatically perform querries whenever the excel table is updated? I cannot find information about this anywhere: all of the triggers and pre-strored processes that I've read about require the user to get onto SQL to use them. Is it even possible to have this SQL version perform this task automatically, or should I look into another kind of SQL package?As a bit of background, I am working on an ambitious (for a begginer) project to create an SQL database that automatically recieves input from a large, and frequently updated, MS excel customer database, interprets the data, and then exports that data to a MS publisher document for customer consumption. I am not looking for answers, just direction and advice. Many thanks in advance for any useful guidance. -MTD |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-07-28 : 11:36:54
|
quote:
Originally posted by LearningSQL2
Russel,Thak you for your help. Now I've gotten SQL to accept the database. My next step is to rig up an SQL database that shares a continuious link with the excel customer database sheet so that the SQL database is triggered to automatically perform querries whenever the excel table is updated? I cannot find information about this anywhere: all of the triggers and pre-strored processes that I've read about require the user to get onto SQL to use them. Is it even possible to have this SQL version perform this task automatically, or should I look into another kind of SQL package?As a bit of background, I am working on an ambitious (for a begginer) project to create an SQL database that automatically recieves input from a large, and frequently updated, MS excel customer database, interprets the data, and then exports that data to a MS publisher document for customer consumption. I am not looking for answers, just direction and advice. Many thanks in advance for any useful guidance. -MTD
Let's continue that discussion here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=163616 |
|
|
|
|
|
|
|
|
Importing Microsoft Excel 2007 Data into SQL