Data dump

C

cricket1911

Is it possible to import data directly from an Excell spreadsheet to populate
an existing Access Database?
 
J

John Nurick

Yes. Use File|Get External Data.

Normally it's best to link to the Excel sheet or to import it to a
temporary table. Then use one or more append queries to move the data
into your actual tables, changing field names and data types if needed.
 
Top