Thread: import excel to access table
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default 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

Reply With QuoteReply With Quote