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 |
|
Juls
Yak Posting Veteran
51 Posts |
 Posted - 2002-07-17 : 12:43:15
|
| Hi,I have an excel spreadsheet with data that I need to use to update data in my table in my SQL 7 DB.Without having to import this spreadsheet into DB as a table and then use it to link to my table, is there a way I can import it into a temp table.What are my options?Thanks,Juls |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-17 : 12:54:07
|
| As a temp table, no, you won't be able to do it. I don't see why it's such a big deal to clear out a regular table and then re-import freshly from the Excel sheet. It's a cinch to do in a DTS package.Alternately, you can try creating a linked server to your Excel workbook. Then you can query it from SQL Server as if it were a regular table.See Books Online for more information on linked servers. |
 |
|
|
|
|
|
Compare excel data to table data