Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Answers
bulk insert to ms access with csv file
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
sy l
14y
7.4k
1
Reply
i try to bulk insert data to ms access db from a csv file.
below my code
DbCommand selectCommand = factory.CreateCommand();
selectCommand.CommandText = @"SELECT * INTO [MS Access;Database=C:\mydb.mdb].[table1] FROM [abc$]";
selectCommand.ExecuteNonQuery();
it work for import excel file, but when i try to input a csv file as below code, it failed
selectCommand.CommandText = @"SELECT * INTO [MS Access;Database=C:\mydb.mdb].[table1] FROM [abc.csv]";
selectCommand.ExecuteNonQuery();
error "Query input must contain at least one table or query."
pls help...
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
How to store changes made in a GUI ?
XML XDocument Load web rss feed link in silverlight