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.
 
Back
Top