question

DharmanDave avatar image
DharmanDave 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 ?
sql-server-2008-r2excel
4 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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 ?
0 Likes 0 ·
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.
0 Likes 0 ·
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...
0 Likes 0 ·
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.
0 Likes 0 ·
Kev Riley avatar image
Kev Riley answered
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
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.