-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copy Query Data To Another Table
- Thread starter ali zaib
- Start date
-
- Tags
- copy & paste access
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
It depends on the kind of query. If it's not a crosstab or a union query, just change the query type. If it is a crosstab or union query, create a new query based on the crosstab / union query and add all the fields to the grid (all the fields, not the asterisk).
In the query design choose Make Table if you want to create a new table. Enter the name of the table, click OK, then click the Run (exclamation mark) icon.
To add the data to an existing table choose Append. Pick the table to add the data to, then in the new grid row that appears, select the fields that the query data will map to, and click the Run button.
You will get a prompt about creating a new table or adding records. Click OK and you're done.
Denis
In the query design choose Make Table if you want to create a new table. Enter the name of the table, click OK, then click the Run (exclamation mark) icon.
To add the data to an existing table choose Append. Pick the table to add the data to, then in the new grid row that appears, select the fields that the query data will map to, and click the Run button.
You will get a prompt about creating a new table or adding records. Click OK and you're done.
Denis
Upvote
0
Similar threads
- Question
- Question
