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 |
|
Wodzu
Yak Posting Veteran
58 Posts |
 Posted - 2008-06-06 : 09:47:45
|
| Hi folks. I am having an excel file. I need to import this file to database and update some other tables with data contained in this file. I would like to automate this process as much as possible.Now, I am just using SQL Server Import Wizard to create a table and then I am running an update query. Is there any (more automate) way to do this?Thanks for your time. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
Wodzu
Yak Posting Veteran
58 Posts |
Posted - 2008-06-06 : 10:50:38
|
| Thank you :) |
 |
|
|
eranhef
Starting Member
1 Post |
Posted - 2008-07-11 : 03:39:10
|
| Hi, you can do this using integration services (SSIS)check this:[url]http://ajaxme.blogspot.com/2008/05/loading-excel-file-to-ms-sql-table.html[/url] |
|
|
|
|
|
|
Import excel file into table via T-SQL?