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 - 2005-07-13 : 07:51:05
|
| Pilar writes "use databasenamegoBULK INSERT filename FROM 'C:\Testing\testdata.txt' WITH (FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n') -- (FORMATFILE = 'C:\Testing\testformat.fmt')Could not bulk insert because file 'C:\Testing BCP\CDS_APCGeneralEpisode_Extract_uFCE_20050527140300.txt' could not be opened. Operating system error code 3(error not found).Can anyone tell me what this message is about and where / how to fix it?I am getting the same error message with or without the format file except, when used, the message is about the format file not the data file.Sql Server 8.0 and Windows XP Professional Service Pack 2.0" |
|
|
jimjamjo
Starting Member
10 Posts |
Posted - 2005-07-13 : 10:15:15
|
| you need to wrap the file path in brackets as there is a space in it '"path"' |
 |
|
|
|
|
|
Bulk insert with format file