asked
How to import data from a .dqy file?
I'm having a .dqy file format from which I required to extract data to a .csv file. What would be the best way to go about it ?
Thanks for your prompt response. What I would like to know is whether there is a way to process the .dqy files so that i get the output .csv. I tried opening the query with Microsoft Query through excel but is throws some error like 'Data source name not found and no default driver specified'. Can i use .dqy files as source in the Import/Export wizard or any similar utility ?
It's a query in Excel. You need to use Excel to at least get the query. If you're getting connection issues it's because Excel can't connect to the database the query was written for. You'll have to fix that issue within excel.
These are the connection string parameters : DSN=; Description=; UID=; Trusted_Connection=; APP=2007 Microsoft Office system; WSID=; DATABASE=; Network= Out of these i do not get what the DSN, WSID and Network parameters expect !! If u can plz tell me what these are for, it might help the cause...
If that's the connection string stored inside the DQY file... I don't know. That's where it's supposed to be. You should get in touch with whoever is providing these things and find out what's up.
DQY is an Microsoft Query OBDC query file - it won't contain any data, it just has a definition of query.
http://support.microsoft.com/kb/164729
Since a .dqy file is a data query file from Excel and you can save .csv files from Excel, I'd probably just use Excel to do that conversion.
11 People are following this question.
