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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-13 : 08:50:39
|
| Eric writes "Is it posible to use the BULK INSERT command with an excel .xls file? Or is there another way of moving a large amount of data to a temporary SQL table from excel.Thanks,Eric" |
|
|
Jay99
468 Posts |
Posted - 2002-03-13 : 09:18:43
|
| No. BULK INSERT requires a ASCII text file, as does the BCP command line utility. However, you can export from excel into a text file format that these two can utilize.There are other easier ways. The Import/Export Data Transformation Services Wizard can directly connet to an excel spreadsheet. You can use the OPENROWSET function to directly connect to any OLEDB data source. You can write a DTS package with a Data Pump task to import the data.Jay |
 |
|
|
|
|
|
BULK INSERT from MS Excel