Insert Dataset into MS-Access

Question

0.00/5 (No votes)

See more:

Hi All,
My Problem is that I have a dataset which I want to insert into MS Access DB. I dont want to fire one by one query on the DB coz the dataset has a bulk of records. So is it possible to insert the whole dataset into MS Access at once? If yes, Then please help.

Thanks in Advance

Posted 12-Jan-11 1:05am

astrovirgin

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Hiren solanki · Answer 1 · 2011-01-12T01:31:00

Solution 2

Thought THIS[^] is not a quite received article in a code project but subject line is matching to your requirement, you may find some helpful info inside.

Or use google keyword 'Bulk insert in Access'

Posted 12-Jan-11 1:31am

Hiren solanki

Comments

Espen Harlinn 12-Jan-11 9:09am

5+ A reasonable answer

Espen Harlinn · Answer 2 · 2011-01-12T01:13:00

Solution 1

This may be of interest:
Bulk Record Insert for Access[^]

You should also, if you can, consider SQL Server Express

Regards
Espen Harlinn

Posted 12-Jan-11 1:13am

Espen Harlinn

Comments

astrovirgin 12-Jan-11 7:18am

Sorry, its not what I want...

Hiren solanki 12-Jan-11 7:34am

@rep to OP: Thought it's not what you want, but surely he/she tried to help you, you shouldn't downvote. It's just a free help.

Espen Harlinn 12-Jan-11 7:50am

Based on the question I'd really like to know what was wrong with the answer - please elaborate ...

Аslam Iqbal 12-Jan-11 8:05am

Why people downvotes when someone tries to help him? got my 5.

Espen Harlinn 12-Jan-11 8:07am

Thanks Aslam!