Importing data from Excel into Access

M

MMC

Can I import data from an Excel spreadsheet into an Access database and
identify what information is updated and what information is not updated?
 
P

pietlinden

Can I import data from an Excel spreadsheet into an Access database and
identify what information is updated and what information is not updated?
Click to expand...

If you include a timestamp in your Access table and update it when
your query runs, you should be able to tell.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access Subscript out of range when importing into access 2010 from excel 0
Import data and update changed information 1
Conditional import from excel 1
Importing unique records from excel into access 2
Help with selective import from Excel. 4
How do I import large Accesss databases into Project? 1
Exporting data in Access fields to cells in Excel 4

Top