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.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Data transformation before doing a BULK INSERT

Author  Topic  jeff37 Starting Member 1 Post Posted - 2004-04-22 : 04:49:04 Hi, I'm doing an import of data from an external file into my database (MS-SQL Server 2000). I use the following command : BULK INSERT dbo.[MyTable] FROM 'C:\Documents and Settings\me\Bureau\MyFile.txt' WITH ( FIELDTERMINATOR = '|' ) Everything is ok but only if the data from this file don't have any line break. And what I want to do is to import HTML file into my database. So I'd like to set well the data from the file before doing the BULK INSERT. Do you know how to do this ? Thanks by advance for your help. Jeff