Update access table with Excel Spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
SITCFanTN said:
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.
Click to expand...

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