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 Data from Queries in Access 2007 to Excel Spreadsheet 1
Export Many Unrelated Access (2000) Data Tables to Excel 6
Export data to access from files in excel 1
export access memo fileds to excel 2
Getting Access and Excel to talk 3
Export Data from an access table to a pre-formatted excel template 1
export 1 record selection in Access database to Excel spreadsheet 1
Exporting Data from Access To Excel 10

Top