Link table to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fenlon - 09 Apr 2005 01:33 GMT

Hi,

I have a report tool at my work that export reports to an .xls file. It
appears that I should be able to link to it from access but I get an error
message every time. If I go into the .xls file and re-save it it prompts me
to save as a text delimited file. This makes me think that the file is not
really in the Excel format. If I go to save as and change the format to
Excel it links every time. How can I get Access to do this for me
automatically? I can export the data from my tool at work to other formats
but none that can be read by Acess. Any ideas?
Thanks,

Jeff

Reply to this Message

John Nurick - 09 Apr 2005 07:42 GMT

It sounds as if the report tool is creating a CSV file but naming it
with an XLS extension.

Can you change this, so it uses .csv instead of .xls? This should not
affect Excel, which cheerfully opens CSV files (and on many computers is
set as the default application for them)? You will then be able to link
it to Access as a text file.

If you can't change the behaviour of the report tool, the instructions
at http://support.microsoft.com/?id=304206 show how to enable Access to
use text files that non-standard extensions.

>Hi,
>
[quoted text clipped - 9 lines]
>
>Jeff

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message