Problem with exported Excel files

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

Guest

I have three queries that create three spreadsheet files. These files are
linked to a main spreadsheet that creates some charts. When I click on
Update, I get three messages saying: "Unable to read file". If I go to each
of the Access generated spreadsheets, open them and then SAVE them, I don't
get that error message and the data is fine (and updated). What am I doing
wrong?
 
How do the queries create the workbooks?

Conceivably the problem is that the workbooks are created in an old
Excel format. IIRC this happens if you use DoCmd.OutputTo or the
OutputTo macro action or "Analyze it with Excel". Instead, use
File|Export or DoCmd.TransferSpreadsheet or the TransferSpreadsheet
macro action.
 
That worked. I changed my macro from using "OutputTo" to
"TransferSpreadsheet" for the output of all three queries. They updated the
spreadsheets and there are no longer any errors when I update the Main
Spreadsheet.

Thanks.

I also was told that OutputTo is a problem with Office11 and that I should
update to SP2. Should I have my IT Department put that on their agenda?

Again, thanks.
 
In general it's a good idea to install the service packs, but I wasn't
aware that there's any particular problem with OutputTo and Access
2003. The business with Excel formats goes back to Access 97 if not
before.
 
Back
Top