How do I change a query to a table in Access 2003?

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

Guest

I would like to change a query to a table within my database. I have
exported the query to excel and then imported as a table but I get the
message that I've lost some data and I'm not sure what data that is! I would
much rather change within the database. I am using Access 2003. Thank you
very much!
 
Change your Select Query (I guess) into a Make-Table Query and run it.

Check Access Help on Make-Table Queries.
 
You must log in or register to reply here.

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

question on tables and queries 5
Table name as a parameter in a query 3
Access Access Queries 0
Can't create a report from my query in Access 1
Exporting query to table in external database 4
Tracking Record Changes Between an Old Table and a New Table 0
import multiple Excel worksheet into a main Access table 1
Replacing a Table with a Table from another database - reference issues 1

Back
Top