mikwat code :: MSSQL Bulk Insert from CSV file

{ 2011 02 17 }

MSSQL Bulk Insert from CSV file

http://www.thescripts.com/forum/thread158756.html

BULK INSERT Test FROM 'X:\temp\Test.CSV'
WITH (
DATAFILETYPE = 'char',
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)

Could not bulk insert because file ‘X:\temp\Test.CSV’ could not be opened. Operating system error code 3(The system cannot find the path specified.).

http://support.microsoft.com/kb/316371

objBL.transaction = "FALSE"

Post a Comment