How can I store query results in a table

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?
 
R

Rick B

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
 
S

Sunny

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

PC Datasheet

Rick,

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

Tom Ellison

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
 
S

Sunny

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.
 
N

New TO Access

Try using a make table query with only the fields that you require for
management
 
Top