Access 2000 Export to Excel (Windows 98 Operating System)

M

Marc Waldman

I developed an Access database that generates excel
reports. When I run the database on a Windows 98
operating system the export to excel function (which just
transfers a static table to an existing excel
spreadsheets) takes between 25 minutes and .5 hours. When
I run the same thing on a 2k operating system it takes
about 10-20 seconds. I cannot figure out how to address
this issue.
 
J

John Nurick

Hi Marc,

You may find a solution here:
http://www.granite.ab.ca/access/performancefaq.htm

I developed an Access database that generates excel
reports. When I run the database on a Windows 98
operating system the export to excel function (which just
transfers a static table to an existing excel
spreadsheets) takes between 25 minutes and .5 hours. When
I run the same thing on a 2k operating system it takes
about 10-20 seconds. I cannot figure out how to address
this issue.
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 

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

Export to Excel successful but old data remains 0
Export data to access from files in excel 1
Damaged Outlook 2010 file prevents indexing. Am I doing the right repairs? 0
export access memo fileds to excel 1
Export Data from an access table to a pre-formatted excel template 1
Export Data from Queries in Access 2007 to Excel Spreadsheet 1
Export to Excel 3
Strange problem exporting query to excel 2

Top