conchefritter
12-02-2005, 04:59 AM
Good Morning,
I'm attempting to dynamically link an Access select query (it does include MIN MAX and SUM) via MSQuery to Excel, where I'll be builing charts and graphs (hate 'em in Access).
It seems simple. From Excel I select Data -> Get External Data -> New Database Query. The Choose Data Source dialogue pops up, and I select Microsoft Access Database* under the Database tab. I select the database (I'm building it, and it has no restrictions). Below the Select Database dialogue box is a small box with a broken red line moving between a PC and server illustrations with the text "Connecting to data source..."
This small "Connecting..." box is still up when I select OK in the Select Database box (wizard checked). My dB tables and queries are listed, but when I click the + box I don't get any fields listing down from any table or any query--just the minus sign.
If I bypass the wizard and attempt to select any of the tables or queries, I get "Can't access table <table/query>".
In dozens of threads in forums, and in MSDN that I explored yesterday, I haven't enountered any discussion of this roadblock. People seem to do this seemlessly. Am I missing something obvious? I'm more comfortable if I can do this from the Excel interface rather than VBA, since I'm not yet proficient in the latter.
Last note: any chance this is a .dll problem requiring a re-install of Excel? That was suggested and it crossed my mind too.
Any help is appreciated. Thanks.
I'm attempting to dynamically link an Access select query (it does include MIN MAX and SUM) via MSQuery to Excel, where I'll be builing charts and graphs (hate 'em in Access).
It seems simple. From Excel I select Data -> Get External Data -> New Database Query. The Choose Data Source dialogue pops up, and I select Microsoft Access Database* under the Database tab. I select the database (I'm building it, and it has no restrictions). Below the Select Database dialogue box is a small box with a broken red line moving between a PC and server illustrations with the text "Connecting to data source..."
This small "Connecting..." box is still up when I select OK in the Select Database box (wizard checked). My dB tables and queries are listed, but when I click the + box I don't get any fields listing down from any table or any query--just the minus sign.
If I bypass the wizard and attempt to select any of the tables or queries, I get "Can't access table <table/query>".
In dozens of threads in forums, and in MSDN that I explored yesterday, I haven't enountered any discussion of this roadblock. People seem to do this seemlessly. Am I missing something obvious? I'm more comfortable if I can do this from the Excel interface rather than VBA, since I'm not yet proficient in the latter.
Last note: any chance this is a .dll problem requiring a re-install of Excel? That was suggested and it crossed my mind too.
Any help is appreciated. Thanks.