Report How many records were imported

[AlexisW]

I have created a script that imports an excel spreadsheet to Access. Now I'm trying to have the script tell the user how many records were imported
I have used the TransferSpreadsheet command, however everytime the user runs the command the range will be different (User picks their own file to import) so I have no idea how many records are imported

Is there any easy way of finding out how many records were imported? It is simply to inform the user what has happened

Thank you for any help!




I have also posting this question here:
http://www.excelforum.com/access-pro...-imported.html

[pbaldy]

I don't think TransferSpreadsheet returns that info. If nobody else would be adding records, you could count the records in the destination table before and after.

[AlexisW]

Thank you so much for the suggestion, it works great!

[pbaldy]

Happy to help, and welcome to the site by the way!