How to import data into existing Table in Access?

K

kmcleary

Using Access 2000. I am trying to import data from Excel and/or Text files
into an existing database. Access will only allow me to import data to a New
Table i.e. 'Import Data to existing table' is greyed out. What am I doing
wrong?

Kevin Cleary
Buenos Aires Argentina
 
V

Van T. Dinh

Link the Excel spreadsheet to the database as Linked Table and use an Append
Query to append Records from the Linked Table to your destination Table.
 
Top