| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import Access Table into Excel. I appreciate your assistance. Thanks! | Excel Discussion (Misc queries) | |||
| Import Access Table into Excel | Excel Worksheet Functions | |||
| Import from Access to Excel, via pivot table | Excel Discussion (Misc queries) | |||
| I can import Access Tables. But, I can't import Access queries | Excel Programming | |||
| When I Import an Access Table With an Excel Function in a Cell it Displays as Text not as a Function in Excel | Excel Programming | |||
Hybrid Mode
