Counting Excel file records from Access 2000

Del · Jul 11, 2008

How can I use Access 2000 code to count the number of records in an Excel
file before I import the files?

pietlinden · Jul 11, 2008

How can I use Access 2000 code to count the number of records in an Excel
file before I import the files?

open a static ADO recordset of the file, then use the .RecordCount
property

Del · Jul 11, 2008

How do I do that?
--
Thank you,
Del

[email protected] said:
open a static ADO recordset of the file, then use the .RecordCount
property

pietlinden · Jul 12, 2008

How do I do that?

you look in the help file under "ADO recordset"