Update access table with Excel Spreadsheet

[Guest]

I've inherited an access database and it automatically imports excel
spreadsheets and convert them it to access tables. I can't figure out how
this
is done, is there VB code that accomplishes this? I've tried to identify the
code but just can't seem to locate it. The name of the excel spreadsheet is
Confirm and updates the ConfirmExcel table in access.

 

[Dirk Goldgar]

I've inherited an access database and it automatically imports excel
spreadsheets and convert them it to access tables. I can't figure
out how this
is done, is there VB code that accomplishes this? I've tried to
identify the code but just can't seem to locate it. The name of the
excel spreadsheet is Confirm and updates the ConfirmExcel table in
access.

It could be done via VBA code or by macros. Code is more likely. The
code could be in one or more standard modules (on the Modules tab in the
database window), or it could be in the class module of a form -- or
even distributed between a form module and one or more standard modules.

What triggers the import? That might tell you where to start looking.