Jump to content

hi problem with bulk insert command


karthikc85

Recommended Posts

hi everybody,i have created a webform with a button to read bulk data from a .CSV file from a path :C:\karfiles\myfile.csviam 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.dllAdditional 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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...