locked
Bulk Copy to ms Access DB using oledb Data Provider RRS feed

  • Question

  • Hi ,

    Is there any way to Bulkcopy to Ms Access DB using oledb provider like SqlBulkCopy?

    I am having Datatable manually created and inserted the bulk Data.


    Thanks in Advance
    Tuesday, December 8, 2009 5:52 AM

Answers

  • Hi,
    In this case if the table structure in Access DB is simple then you create OledDB DataAdapter from it. And using this DataAdpater you can easily push and pull information / data between your datatable and Access DB.
    This is something similar to BulkCopy.

    Manish Patil http://patilmanishrao.wordpress.com Posting is provided AS IS with no warranties, and confers no rights.
    Tuesday, December 8, 2009 6:41 AM
  • There is nothing comparable to the SQLBulkCopy Class but you can still use a Dataset to export the data.

    http://www.knowdotnet.com/articles/datasetmerge.html


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Tuesday, December 8, 2009 4:36 PM

All replies

  • Hi,
    In this case if the table structure in Access DB is simple then you create OledDB DataAdapter from it. And using this DataAdpater you can easily push and pull information / data between your datatable and Access DB.
    This is something similar to BulkCopy.

    Manish Patil http://patilmanishrao.wordpress.com Posting is provided AS IS with no warranties, and confers no rights.
    Tuesday, December 8, 2009 6:41 AM
  • Hi Patil,

    Thanks for your reply.

    Please provide sample code for this concept.

    Regards,
    Kalees
    Tuesday, December 8, 2009 6:49 AM
  • There is nothing comparable to the SQLBulkCopy Class but you can still use a Dataset to export the data.

    http://www.knowdotnet.com/articles/datasetmerge.html


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Tuesday, December 8, 2009 4:36 PM