Data dump

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to import data directly from an Excell spreadsheet to populate
an existing Access Database?
 
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.
 
Back
Top