Home |
Search |
Today's Posts |
#1
|
|||
|
|||
linking to .mdb table
Can I create a new Excel spreadsheet linked to an existing Access table.
Creating an access table linked to an existing .xls is not an option in this case. The .xls would preferably be "read-only" but that isn't TOO critical an issue. (Will be resolved in Apr '05 when we can buy more ACCESS licenses, but budgetary restraints in place now) Only option I've seen is to Drag the required Access tables into .xls then create new access tables linked to XL tables... there MUST be a better way!!! Thanx - David |
#2
|
|||
|
|||
Hi
try 'Data - Import external Data' for this "David#" wrote: Can I create a new Excel spreadsheet linked to an existing Access table. Creating an access table linked to an existing .xls is not an option in this case. The .xls would preferably be "read-only" but that isn't TOO critical an issue. (Will be resolved in Apr '05 when we can buy more ACCESS licenses, but budgetary restraints in place now) Only option I've seen is to Drag the required Access tables into .xls then create new access tables linked to XL tables... there MUST be a better way!!! Thanx - David |
#3
|
|||
|
|||
I don't see that option... we have office 2000... under"Get External Data"
menu, I have 3 Query options plus option to import a .txt file. The "run Database Query" isn't getting me where i need to be. "Frank Kabel" wrote: Hi try 'Data - Import external Data' for this "David#" wrote: Can I create a new Excel spreadsheet linked to an existing Access table. Creating an access table linked to an existing .xls is not an option in this case. The .xls would preferably be "read-only" but that isn't TOO critical an issue. (Will be resolved in Apr '05 when we can buy more ACCESS licenses, but budgetary restraints in place now) Only option I've seen is to Drag the required Access tables into .xls then create new access tables linked to XL tables... there MUST be a better way!!! Thanx - David |
#4
|
|||
|
|||
Hi
use the 'Create new query' option to link/import data from your Access table "David#" wrote: I don't see that option... we have office 2000... under"Get External Data" menu, I have 3 Query options plus option to import a .txt file. The "run Database Query" isn't getting me where i need to be. "Frank Kabel" wrote: Hi try 'Data - Import external Data' for this "David#" wrote: Can I create a new Excel spreadsheet linked to an existing Access table. Creating an access table linked to an existing .xls is not an option in this case. The .xls would preferably be "read-only" but that isn't TOO critical an issue. (Will be resolved in Apr '05 when we can buy more ACCESS licenses, but budgetary restraints in place now) Only option I've seen is to Drag the required Access tables into .xls then create new access tables linked to XL tables... there MUST be a better way!!! Thanx - David |
#5
|
|||
|
|||
Thanx - now we're there!!
"David#" wrote: Can I create a new Excel spreadsheet linked to an existing Access table. Creating an access table linked to an existing .xls is not an option in this case. The .xls would preferably be "read-only" but that isn't TOO critical an issue. (Will be resolved in Apr '05 when we can buy more ACCESS licenses, but budgetary restraints in place now) Only option I've seen is to Drag the required Access tables into .xls then create new access tables linked to XL tables... there MUST be a better way!!! Thanx - David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Linking Combo box to pivot table? | Excel Discussion (Misc queries) |