hi everybody,

i have created a webform with a button to read bulk data from a .CSV file from a path :C:\karfiles\myfile.csv

iam using a bulk insert command to insert all records into database in VS 2005 WINDOW APPLICATION C# USING SQL SERVER 2005.

when i click the button iam getting this exception :

"An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Additional information: Could not bulk insert because file 'C:\karfiles\myfile.csv' could not be opened. Operating system error code 3(The system cannot find the path specified.)." at cmd.executenonquery.

i want to trouble shoot this exception .

please can anybody help me?

thanks,
karthik.

Hi Karthik,

First make sure you have been granted access as sysadmin or bulkadmin.

Secondly make sure the file exist in the same path.

Thirdly make sure you are using this command:

BULK INSERT <YourTableName>
FROM 'c:\karfiles\myfile.csv'
WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' )

If still not executing then let me know.

Regards,
Danish Sami.