Uploading an excel data to Access database

Question

How can i upload an excel data to an Access database ? I also want to check any duplication of records while Uploading. Can u Help me?

Mahesh Chand · Answer

You need to read Excel data in a DataSet and use OleDbDataAdapter to connect to the Access database and upload data into Access database. Check out Office Interop section of VB.NET Heaven site for how to open and read Excel data into a DataSet. Check articles by Mike Gold. Check ADO.NET & Database section on how to connect and add data to an Acess database. Alternatively go to site home page ( www.vbdotnetheaven.com ) and search for read Excel DataSet and Access database related keywords in the SEARCH control.