How can I store query results in a table

  • Thread starter Thread starter Sunny
  • Start date Start date
S

Sunny

I have a query designed from one table only and I want to store query
results in a table. I tried to use DoCmd.TransferDatabase, but I get error
"can not defined field more than once". I have long field names in my
original table. Is there any other way I can export results with its
original field names?
 
Why would you want to duplicate the records that are the result of your
query?

If you will read through previous posts, you will find countless times where
this is discouraged. Godd database design does not include duplicating data
in more than one table.

Rick B
 
This is because I want to export results into different database for some
other purpose.
 
Rick,

You made me a believer!! If it's good enough for God, it's good enough for
me. :)
 
Dear Sunny:

By all means, write a query that produces what you want in that "other
database" and export the information using that. No need to store any
derived data in your existing database.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
I am sorry, I have not described enough. I need to send new database to
management people for further analysis in different state. The whole
database is more than 2 GB and they dont want whole information to be send.
I hope now you understand why I need to store query result in table.

Thanks.
 
Back
Top