how do I automatically update a table with excel inforamtion

[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.

 

[Jeff Boyce]

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

 

[Don]

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

 

[Jeff Boyce]

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