Exporting excel 2003 contents to access 2003 database using vb.net 2003

• • Reply

  12 years ago

  by faysal_002299

  Kamrul Hasan

  , Korea

  Joined 12 years ago
  I need to develop an windows based application in vb.net 2003. I have access 2003 database where an exisiting data with primary key( for combination of 3 fields).I need to import data from excel 2003 and add to the existing records of access database.Before adding, it should check for any existing records in access databaseWith the help of  primary key( only unique records).only new records should get inserted into database.my excel file may contain more than 2000 records with around 15 columns.             I’m finding it very difficult to proceeed for writing code for this in vb.net 2003 as I’m a beginner. Pls help me in this regard…any sample codes wil help me a lot… Thanks all in advance for ur co-operation…Have a pleasant day..Regards,Chandru

   

  Report abuse