import excel to access table

  • 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 it to an access table. 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.
 
hi,
my guess is that the code is in the access database since it is importing
automaticly. there is several ways to do this but without more info i would
be hesitant to gues which. my suggestion at this point is to post in the
access newgroup with more detail about the "automatic import".

regards
FSt1
 
The Excel sheet may be linked to the Access database as a table
(File>Get External Data>Link Tables)

To see the links in the database, or change them, choose Tools>Database
Utilities>Linked Table Manager.
 
Back
Top