>> Opening a *.dqy Data Query file

J

Jonathan

Hi, I have saved a bunch of Query Table sql files. I want to use VBA to open
these files to retreive the command text.

Any ideas or suggestions appreciated :)
 
T

Tim Ferguson

Hi, I have saved a bunch of Query Table sql files. I want to use VBA
to open these files to retreive the command text.
Click to expand...

From a short inspection, it does not look too hard to scrape it out with a
text editor. Try

Input Line #myFile, aString

HTH

Tim F
 
Top