slow export

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that results in about 30 records with about 6 fields. After I
run the query and open the result I try to export to Excel and the export
takes about 20 minutes. The file size of the whole database file is about
100 MB. Does this seem like a long time for an export?

thanks,
Rob
 
Hi, Rob.
Does this seem like a long time for an export?
Click to expand...

Nope. Not for Access. But you can avoid it. Select Tools -> Office Links
-> Analyze It with Microsoft Excel, and you'll see how fast the export should
be. If you need specific formatting of the output, then write a query that
exports the data to a CSV file on your hard drive, and then open the file in
Excel.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
 
I would have to disagree. 20 minutes to run a query with 6 fields and 30
rows is very long. We regularly import and export much larger queries than
that in seconds.
 
Hi, Klatuu.

If you have a simple query, then it does indeed take very little time, even
with a fairly large amount of data. Make it a complex query with linked
tables, multiple correlated subqueries in the SELECT clause, multiple JOINs
with inline correlated subqueries, some VBA code for calculated columns
(particularly in the WHERE clause), or perhaps several UNIONs (without UNION
ALL) -- and the speed of the export is glacial, even if proper indexes are
placed on the relevant columns. The same query "Analyzed with Excel" via
the built-in CommandBar button will export the data in a small fraction of
the time, so there's a huge difference in the amount of patience one needs
to get the same job done.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Back
Top