Import from Excel

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

Guest

Hi,

I created a database which was populated with data exported from an Excel
file. How do I update the database for current information without affecting
the data already in the database? Again, I will be exporting from an Excel
file, unless there is a more efficient way to do this.

Thanks much and Happy Thanksgiving!
 
Hi Shirley,

Make sure there's a field in your table that can distinguish between
data that came from Excel on different occasions. With luck there'll
be a date field or another field in the Excel data that makes this
possible. If not, add a field to the table and use it to store the
date the data was imported, or the name of the Excel file or some
such.
 
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

Export data to Excel Column 1
Exporting Data from Access To Excel 10
Importing in Access from Excel creating relationships 1
Export data to access from files in excel 1
Exporting/Importing between databases 2
Importing hypertext field in Excel 2003 3
Importing data from Excel into Access 1
Conditional import from excel 1

Back
Top