Counting Excel file records from Access 2000

  • Thread starter Thread starter Del
  • Start date Start date
D

Del

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access Dcount function in access 0
Record insert/delete anomaly 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel Macro to record word and pdf page count in Excel 2
Table Record Counts from System Tables 2
counting records 0
Excel records scramble after import to Access 2000 11

Back
Top