Importing Text Data Into a Table

[DBADoug]

I have a table schema as follows:

field1 datetime
field2 float
field3 varchar(50)

I am attempting to import a text file, with records in the following layout. Here's a sample record:

11/16/2003 12:10a 146,944 log_dump.11160010

I've tried using BULK INSERT, but each time, it tells me that 0 records were inserted. There are no syntax errors. I even created a format file from a bcp export that I tweaked to align up with the text file layout, but I get the same results.

Any help pointing me the right direction would be appreciated. Thank you.

 

[JayKusch]

First of all, can you use Enterprise Manager. If so, drill down to your table w/in the database. Right-click on the table and choose "All Tasks" then "Import Data" set your source as a text file and the point it to your file. The rest of the questions should be self-explainatory.

Is your file comma or tab delimited ... or delimited at all. Let us know how this works out for you!

Thanks

J. Kusch

 

[nigelrivett]

see

http://www.nigelrivett.net/ImportTextFiles.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[DBADoug]

J ... I'm writing this as part of a script, and therefore cannot use enterprise Manager, which makes it easy. The file is the output of a dos DIR command, piped to a text file, so I'm not sure how the delimited state is, but I don't think it is straight tab delimited.