Link table to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top