Excel Download Error

  • Thread starter Thread starter geebee
  • Start date Start date
G

geebee

Hi,

I have a button with the following code behind it:

DoCmd.OutputTo acTable, "FY02_BASETABLE", "MicrosoftExcel
(*.xls)", "U:\Travel Desk\Downloads\FY02_BASETABLE.xls",
True, ""


But when I click the button, I get the following error
message:

"File Error. Some number formats may have been lost."

Why am I getting this message?

Is there a better more robust way to do downloads?

Thanks in advance,
geebee
 
Only a guess -- perhaps some of the data is ambiguous and the Method cannot
resolve this.

Have you tried using a query to force all fields to specific data types,
with the "Convert" functions (e.g., CStr(), CLng(), ... CDbl())? You can
base your export on a query instead of a table.
 
Back
Top