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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Data from Access To Excel 10
Importing Data with More than One Item per Field 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Question 3
Importing data from Excel into Access 1
How do I automate a reoccuring data load from Excel to Access? 1
Importing data from Sharepoint 2007 to Access 2003 0
Using Data in an Access Form to fill in Excel Spreadsheet 2

Back
Top