Access 2000 Export to Excel (Windows 98 Operating System)

  • Thread starter Thread starter Marc Waldman
  • Start date Start date
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.
 
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.
 
Back
Top