Uploading an excel data to Access database
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?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Mahesh ChandPosted Aug 23, 2007, 7:52 AM
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.