Moving data from table to table

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

Guest

I have a table that contains a lot of data, and I am now creating new tables
to split the data up. How do I do to only get some of the data in the old
table to a new one? For example one or two columns.
 
Falin said:
I have a table that contains a lot of data, and I am now creating new
tables to split the data up. How do I do to only get some of the data
in the old table to a new one? For example one or two columns.
Click to expand...

Check help for "Append query".
 
SELECT Col1, Col2 INTO MyNewTable FROM myOldTable Where ifanycondition
 
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

VBA - retrieve data on last create named range from previous inserted named range 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to Populate Data from a table to another 0
how do I add data from one table to another table? 4
Combining data from 2 linked tables 1
combine tables 1
Table data update 5
Appending to normalized split tables 2

Back
Top