import excel to access table
 

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.

import excel to access table
 

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

"SITCFanTN" wrote:

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.

import excel to access table
 

you can link to an excel workbook through the File=Get External Data=Link
Tables.

--
Regards,
Tom Ogilvy

"SITCFanTN" wrote in message
...
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.

import excel to access table
 

The Excel sheet may be linked to the Access database as a table
(FileGet External DataLink Tables)

To see the links in the database, or change them, choose ToolsDatabase
UtilitiesLinked Table Manager.

SITCFanTN wrote:
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.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html