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 |
|
JeffT
Posting Yak Master
111 Posts |
 Posted - 2007-02-28 : 11:16:43
|
| Hi,I received data in an Excel spreadsheet and want to save it to a file and then BCP that file into a table. I'm not sure what file format to save the Excel data to. I have tried saving as tab delimited text and csv file but keep getting a "unexpected EOF encountered in BCP data" error.Thanks,J. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-02-28 : 11:38:42
|
| why don't you just use openquery and import files directly from Excel file?Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-28 : 11:43:48
|
if this is a one time job, you can use DTS to import the excel file
KH |
|
|
|
JeffT
Posting Yak Master
111 Posts |
Posted - 2007-02-28 : 12:10:48
|
| Thanks spirit1 and khtan. I'm not familiar with openquery, I will look into that. This will be an ongoing job.J. |
|
|
|
|
|
|
BCP into table from