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-06-12 : 08:04:06
|
| sakkaravarthi writes "How can I use the BLUK INSERT to upload an Excel file?. Please give the details about FIELDTERMINATOR AND ROWTERMINATOR of Excel." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-12 : 08:12:20
|
| You can't use BULK INSERT with a native Excel file (.XLS extension). You can use it for comma-separated files (.CSV extension). If you have a native Excel file you can either use DTS to put the data into SQL Server, or save the file as a CSV file and use BULK INSERT or bcp.Books Online has all of the documentation you need to use BULK INSERT. The Excel help file will detail how to save files as CSV.Edited by - robvolk on 06/12/2002 08:12:50 |
 |
|
|
|
|
|
BULK INSERT