copy from one table to another in access

I was given a table on access database that need to be exported into an existing database in access , the column names are different but the data will fit into the existing table,  there are however columns that will remain null.


How would I do this?  I cannot select copy past since the data is not same order,,,
LVL 9
TonyRebaAsked:
Who is Participating?
 
IrogSintaConnect With a Mentor Commented:
Insert this in a query SQL view.
INSERT INTO DestinationTable (NameOfColumn1, NameOfColumn2) SELECT NameOfSourceColumn1,  NameOfSourceColumn2 FROM SourceTable
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
you will need to create a query against the source table that will match the fields of the destination table.

if you find it difficult to do this, upload a copy of the source db and destination db.
0
 
TonyRebaAuthor Commented:
I have both tables now in a same database.

But I need to copy fields from table 2 to table 1,

Is there any nechanism in access to do this , do I have to create a custom query???
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Rey Obrero (Capricorn1)Commented:
<Is there any nechanism in access to do this> Yes, the query i mentioned above
0
 
TonyRebaAuthor Commented:
How do I run it
0
 
TonyRebaAuthor Commented:
got it this is the query used:

INSERT INTO tbl_Providers(Provider_Type,Group_Business_Name,Address,Address2,City,State,Zip)
SELECT
ProviderType,
PHARM_NAME,
Address1,
Address2,
CITY,
STATE,
ZIP_CD_5 FROM s ;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.