Attached Excel sheet in Access stops after every 500 records

Attached Excel sheet in Access stops after every 500 records

Post by tonybr.. » Sun, 12 Nov 2000 04:00:00

I have attached an excel sheet to an access database to process the data. I
have a record counter showng the progress of record being processed. The
counter whizzes along for 500 records and then stops for one or two minutes.
This is repeated for every 500 records.

Is there any way of speeding up the process as I have sheets with 20-30,000
records in.

The system is obviously buffering it somehow but is there any way of
changing the buffer size?

If anyone knows what I'm talking about and can suggest an answer would you

and the request is quite urgent.

Thanks in Advance

Best Regards

Tony Brown


1. Why do tables appear twice when attaching excel sheet

I am using DAO in VB5.

When I attach an excel 97 (or 5 for that matter) spreadsheet and list
the tabledefs in the object, tables(sheets) appear twice.  Once as
labeled and once with a $ appended to it.

ie.  FirstNames

when I want to reference the table, I have to reference it with the
dollar sign.

Any ideas why and where this is documented.


Sent via
Share what you know. Learn what you don't.

2. Deleting Rows from a very large table

3. XML Style Sheet HTTP 500 Internal Error

4. concatenate

5. DBMS selection for 500+GB and 500+users

6. SQL Server questions

7. DBMS Selection for 500+GB data and 500+ Users

8. SQL-DMO and stored procedures

9. can not access numbers in excel sheet

10. how to access cells in existing diferent excel sheets using visual basic

11. Appending Excel Sheets to an existing Access Database

12. How to improve speed in accessing data of Excel sheet with ADO

13. accessing Excel sheet through ADO: problem with Greek language