Using OutputTo Action to export query results in Excel

P

Pants00

I have been able to get the query results to export to the desired file path,
but when I go to open it I get a dialog box "Windows cannot open this
file"..."To open this file windows needs to know what program created it"

I specified in the OutputTo action to use Excel

Any help would be appreciated

Thanks!
Pants00
 
J

JLatham

Does the file have a .xls file type extension on it? If not, that would
explain it.

If it does then you probably don't have a file association for .xls type
files.

Next time you try to open one like that it should also ask you what file
you wish to open this type of file, use the "Select the program from a List"
option (working from memory, may not be exact words) and then look down the
list for Microsoft Office Excel and choose it. If Excel is not in the list,
then you'll have to browse for Excel.exe which will probably be in a location
similar to:
c:\Program Files\Microsoft Office\Office11
location may vary depending on version of Office/Excel you're using. Could
do a search for excel.exe before beginning this to locate it. Identify the
file, choose Always open this type of file usin this program and click OK.

But if you've got Excel already on your system and can open up other .xls
files, I'm betting the file you're exporting to does not have a .xls or .csv
file extension as part of its name.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top