Importing data from table to table with ID

[icloudy67]

I used to use “File Maker” so relatively new to MS Access.,,,,,,
I have a master table of pre structured stamens spread over 8 fields per record( commonly used ones when compiling a report for a client)

• For the site specific report,
  I wish to be able to type in the record number (record ID) from the source table,
  so as for the record to appear in the new table
  where I can ether leave it alone as formatted or change the text slightly without affecting the original text in the source table. (an automated cut and past?)

 

[llkhoutx]

Import your a data, use an Access make table query using the imported table to create a new table, maybe adding your new column and populating it in that query.