G Guest Dec 8, 2004 #1 Is it possible to import data directly from an Excell spreadsheet to populate an existing Access Database?
Is it possible to import data directly from an Excell spreadsheet to populate an existing Access Database?
J John Nurick Dec 8, 2004 #2 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.
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.