A1VBCode Forums

help with excel and access importing


http://www.a1vbcode.com/vbforums/Topic30823.aspx

By chaw12 - 10/22/2011

Hi to all!



I've created a simple program which will import all the data in an excel file to a database or more likely inserting the excel data to access database. but can someone please help with this!. I want my program to automatically write all the duplicate data in a different sheet of the excel file if it has found a similar or existing data on the access database. And if there are some duplicate data found I want the excel to access importing to skip on it and continue saving all those other data that has no duplicate on the database. By the way I've create an excel template with an exporting button and it is where the code resides and the data will be encoded also on the template. Hope some would help me with this..





Thanks in advance!