How to Import data from a Table?

  • Thread starter Thread starter SinCity
  • Start date Start date
S

SinCity

I have two tables. How can I import the data from one into the other?

Also will I need to make sure the column names are the same?

Thanks!
 
SinCity said:
I have two tables. How can I import the data from one into the other?

Also will I need to make sure the column names are the same?

Thanks!
Click to expand...

You can use an append query. Make a query based on the "from" table and
in design mode, look at the top line menu under query and select append.
Answer the questions. You do not need to make the names of the fields the
same, but I would suggest that things will go smoother if the data types are
the same.
 
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

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
Import to many to many table 7
Replacing a Table with a Table from another database - reference issues 1
How to export table from outlook into ms access table? 0
merging data between two tables 6
Easy Steps to Import PST Files to Office 365 0
Importing into existing table 5

Back
Top