Query export as Table

H

Hazzy

I am using access to manupulate a huge data set and the database is getting
really slow.

Is it possible to export the data in a query into a table in a new database.
I have tried to do it but access keeps importing as a query in the new
database.
 
J

John W. Vinson

I am using access to manupulate a huge data set and the database is getting
really slow.
Click to expand...

What's "huge"? Anything under 100000 records should be trivial; up to a few
million will require proper indexing and good query design, but should be well
within Access' capabilities.
Is it possible to export the data in a query into a table in a new database.
I have tried to do it but access keeps importing as a query in the new
database.
Click to expand...

I see you figured out your answer...
 

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

Make Table Query with path Parameter 1
SQL to export query into table 1
Delete query with joined tables 0
Troubleshoot Select Table - Mail Merge in Word from Access Query 1
two access table in one query 2
How to Retrieve Data From Another Access Dataase Without Linking to It? 1
Make-table query with around 2 ml records taking too long 0
Add Table Name as Field in an Append Query 1

Top