Saving dataset into access

Posted on 2006-03-21
Last Modified: 2010-08-05
Can someone provide me with a small snipplet to store a dataset into access database?

Question by:godwindotnet
    LVL 6

    Accepted Solution

    Hi godwindotnet

    I answered another question that although was driven by a need to understand the datagrid, I posted code in order to take data and populate an access database.

    This is the link

    Let me know if you want any more info or explanation

    HTH :)
    LVL 41

    Assisted Solution

    I've got a VB.Net module that will do what I think you're after...

    It's designed for "archiving" a DataSet to a new Access mdb file... so it contains lots of code for creating the MDB file (if it doesn't exist) and creating the Table (if it doesn't exist).  Then towards the bottom of the code, it actually does the copying of data.  

    It uses COM-based ADOX library so it's a bit faster than a "native" .Net solution.

    it works like this:

        Copy_dt2MDB(DataTable, "C:\Testing.mdb", False, "Table1")
    LVL 6

    Expert Comment

    ...are we done here?

    Author Comment

    Yeah,there you go..Ive given the points..:)
    But I wish you couldve given me a little snipplet for this job.It wouldve been more handy than all that code.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
    The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now