D Del Jul 11, 2008 #1 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?
P pietlinden Jul 11, 2008 #2 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
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
D Del Jul 11, 2008 #3 How do I do that? -- Thank you, Del [email protected] said: open a static ADO recordset of the file, then use the .RecordCount property Click to expand...
How do I do that? -- Thank you, Del [email protected] said: open a static ADO recordset of the file, then use the .RecordCount property Click to expand...
P pietlinden Jul 12, 2008 #4 How do I do that? Click to expand... you look in the help file under "ADO recordset"