How to count # of records and display in table?

[BlueStarBrite]

I have an excel spreadsheet and a text file that I want to import into a table. So, how do I count the number of records in the spreadsheet or text file and display that into the table as well? Thanks!

 

[RuralGuy]

The RecordSet.RecordCount will tell you how many records in the table after you have done a .MoveLast.

 

[gemma-the-husky]

yes, you dont store data about the number of rows in an access table - access just knows what this number is

number_of_records = dcount("*","mytable")

------
if you have query that selects just some of these rows (similar to an excel filter) then

number_of_records = dcount("*","myquery") does a similar job.