How to count and display the number of records imported into an Access Table.

[John S via AccessMonster.com]

How would you go about counting just the number of records imported into an
existing populated Access table? My import process using the Spreadsheet
Transfer method works perfect. I would like though a user who does this
import to be able to see a message telling her the number of records that
actually went into this table using the import Spreadsheet Transfer method.

Is there a way to program Access to display to a user the number of records
that were imported into an existing table using the Spreadsheet Transfer
method?

 

[TC]

This VBA code will display the number of records added to table BLAH:

(untested)

dim x as long
x= dcount("*", "BLAH")
(do something here)
x = dcount("*", "BLAH") - x
msgbox x & " records added"

Not sure what that has to do with Access Security, the topic of this
particular newsgroup ...

HTH,
TC