Input records from one table to another

B

Ben

Hi...here's what i need to do....extract data from a table that matched a
specific date and input that data into a new table

Appreciate your help :)
 
A

Alex Dybenko

Hi,
best - is to use INSERT (append) or make-table query - first make a select
query, which extract data from a table, then change query type to append or
make-table query and then specify existing table (append query) or new
table (make-table query )

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
B

Ben

Thats great...thanks

Alex Dybenko said:
Hi,
best - is to use INSERT (append) or make-table query - first make a select
query, which extract data from a table, then change query type to append or
make-table query and then specify existing table (append query) or new
table (make-table query )

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
Click to expand...
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
VBA - retrieve data on last create named range from previous inserted named range 0
How to export table from outlook into ms access table? 0
How to Populate Data from a table to another 0
Add one year in second combobox in vba 0
Copy data from one databse tabel to other database table 1
Updatable ... not 7
Input mask 4

Top