Hi,
Two questions (background below):
1. Why did Excel suddenly start prompting me to specify a ODBC data source?
2. How can I edit old *.dqy queries in MS Query now that it gives the error "Data source name not found and no default driver specified"?
Explaination:
I have a workbook that contains several macros (recorded many years ago, not written from scratch) that call on some *.dqy query files (also created many years ago, using MS Query) to query data located one worksheet and output the results into different worksheets. I currently use Excel 2003 on Windows XP.
About a year ago, I was working on a different project using SQL and databases using OpenOffice Base. After the first time I used that software, Excel suddenly started asking me to specify an ODBC data source when running my old macros in this old workbook. I was puzzled, but fixed it by making a new data source out of the workbook. Why did this start happening? Can I make it stop?
Now these macros have stopped running again (getting stuck at .Refresh BackgroundQuery:=False). In an effort to debug, or perhaps just rewrite the macros properly, I tried to check the *.dqy query files in MS Query. However, MS Query does not seem to like that these files were created before my computer suddenly started wanting me to specify ODBC data sources, and gives the error "Data source name not found and no default driver specified" followed by "Couldn't read file".
Any insights welcome. This ODBC stuff is all new to me!
Thanks!
-Amanda
Two questions (background below):
1. Why did Excel suddenly start prompting me to specify a ODBC data source?
2. How can I edit old *.dqy queries in MS Query now that it gives the error "Data source name not found and no default driver specified"?
Explaination:
I have a workbook that contains several macros (recorded many years ago, not written from scratch) that call on some *.dqy query files (also created many years ago, using MS Query) to query data located one worksheet and output the results into different worksheets. I currently use Excel 2003 on Windows XP.
About a year ago, I was working on a different project using SQL and databases using OpenOffice Base. After the first time I used that software, Excel suddenly started asking me to specify an ODBC data source when running my old macros in this old workbook. I was puzzled, but fixed it by making a new data source out of the workbook. Why did this start happening? Can I make it stop?
Now these macros have stopped running again (getting stuck at .Refresh BackgroundQuery:=False). In an effort to debug, or perhaps just rewrite the macros properly, I tried to check the *.dqy query files in MS Query. However, MS Query does not seem to like that these files were created before my computer suddenly started wanting me to specify ODBC data sources, and gives the error "Data source name not found and no default driver specified" followed by "Couldn't read file".
Any insights welcome. This ODBC stuff is all new to me!
Thanks!
-Amanda