Check Imported data from excel

[naitx]

Hi,

I have a query that will import excel file to access database,Is there a query that will check if the excel file was successfully imported?Or is there other way to do it...?


Thanks in Advance!

 

[smedvid]

Perhaps you can dynamically link to the Excel File; and then setup a query to compare check sums, record totals, etc. between the linked Excel object and the newly imported data.


Steve Medvid
IT Consultant & Web Master

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...