I'm trying to import a text to the SQL Server using the following systax:
FIELDTERMINATOR = '\t',
ROWTERMINATOR = '\n'
But I'm getting this error message:
Cannot bulk load because the file "c:\QDesk\CM\Access2010\CMSTI90.txt" could not be opened. Operating system error code 3(The system cannot find the path specified.).
I checked the text file is there in the specified location. Please let me know what I did wrong.