Hello,
Any way to point this code to a .accdb on the C drive? So that it updates that database using the csv file.
using (SqlBulkCopy bc = new SqlBulkCopy("server=(local);database=Test_CSV_impex;Trusted_Connection=True"))
Thanks
Hello,
Any way to point this code to a .accdb on the C drive? So that it updates that database using the csv file.
using (SqlBulkCopy bc = new SqlBulkCopy("server=(local);database=Test_CSV_impex;Trusted_Connection=True"))
Thanks
try this Google search for connecting to that type of file:
http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=c%23+accdb
in short, no. You can't use SqlBulkCopy on the access database, but there are other, slower methods. You could parse the file, and populate row by row.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.