Last post Aug 12, 2008 02:40 PM by Mikesdotnetting
Aug 12, 2008 05:41 AM|deeps_rock|LINK
hey friends, i am uploading data from excel sheet to database... my problem is data on my excel sheet is huge and i want to know whether data is already present in database or not before uploading it to database...
what can i do...
Aug 12, 2008 02:40 PM|Mikesdotnetting|LINK
One way is to load it into a staging table, then copy the rows across that don't match, then delete the contents of the staging table. You can use the Access query builder to get the SQL syntax for a "Find Unmatched" query. For a quick way to load an Excel
spreadsheet into Access, read this: http://www.mikesdotnetting.com/Article.aspx?ArticleID=79