linking to .mdb table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Hi
use the 'Create new query' option to link/import data from your Access table
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

erratic response while working on a table in excel linked to a tab 2
Excel ODBC driver created table/data not persistent 2
query links to SQL server and mdb table 1
Automatically Refresh pivot table 6
Access Import & Link section grayed out MS Access 2010 1
Linking to external tables/Graphs 1
Excel Pivot Table connected to an Access Database Data Source 2
Changing Database links? 3

Back
Top