how do I automatically update a table with excel inforamtion

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I have a database I want to update with information from excel automatically
but only if I choose to per record. So as I type a field in a form I want it
to find a matching field in the excel spreadsheet and automatically fill out
the rest of the fields in the form at which point I can edit the information
or use the selected information by pressing the *next record button. Any
ideas would be greatly appreciated.
 
Don

Since the data already exists in Excel, what would having a copy of the data
in Access allow you to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Well it's a weed abatement program in access and I am importing a list from
the assessor's office so I do not have to do redundant data entry of mailing
addresses
 
Don

If you aren't "updating" the Excel source, just looking at it, you can
simply link to the Excel source.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top