[ Already Posted on the Access VBA Forum ]
Hi.
I have a database that, on a monthly basis, can import anything from 8000 to 40000 records from excel into access.
I can easily set up an import that deals with named ranges. My problem is how to import using non-named ranges, i.e. to get Access to somehow count the row that have data in them in Excel and to then assign the count variable and import.
I know that I could do a simple loop and travel down my excel data testing the cell contents and moving on etc..and count, but when I tried this on 40000 records it took far too long.
Is there a method or object within excel that can quickly count a cells status, i.e. whether it is populated or not?
If I could find out how to quickly check the cells in excel to find out how many rows are populated my problem would be solved.
Thanks for anything.
Russie
Hi.
I have a database that, on a monthly basis, can import anything from 8000 to 40000 records from excel into access.
I can easily set up an import that deals with named ranges. My problem is how to import using non-named ranges, i.e. to get Access to somehow count the row that have data in them in Excel and to then assign the count variable and import.
I know that I could do a simple loop and travel down my excel data testing the cell contents and moving on etc..and count, but when I tried this on 40000 records it took far too long.
Is there a method or object within excel that can quickly count a cells status, i.e. whether it is populated or not?
If I could find out how to quickly check the cells in excel to find out how many rows are populated my problem would be solved.
Thanks for anything.
Russie
