Exporting from Access to Excel

[Guest]

Hi,
When I'm trying to export a report from Access to Excel file its changing
the values. Like, I'm giving a value "1-1" in one field and is having a data
type "text". And when I'm exporting the report to Excel the above field value
is changing to 38353.
I'm wondering why its changing!
Please answer my question ASAP as my report is pending because of this issue.
Thank You

 

[Maria Eugenia Pumar]

Hello

 

[Guest]

Hello


Are you online to answer my question?

 

[fredg]

Hi,
When I'm trying to export a report from Access to Excel file its changing
the values. Like, I'm giving a value "1-1" in one field and is having a data
type "text". And when I'm exporting the report to Excel the above field value
is changing to 38353.
I'm wondering why its changing!
Please answer my question ASAP as my report is pending because of this issue.
Thank You

If you are using the Analyze with Excel tool button that appears to be
normal behavior. It is obvious that Excel is assuming 1-1 is a date
and that you really mean 1-1-2005.
A date of 1-1-2005 is stored as the number value 38353.
Text values which are unambiguous, such as 13-205 are correctly
exported.

If all the records have in an ambiguous 1-1 text format, i.e. 1-5,
9-3, etc., you can correctly export the data as text by entering
@-@
as the report control's format property.

A better solution may be that you not use the Analyze tool button to
export the finished report, but export the report's record source to
Excel using The TransferSpreadsheet method and then do whatever
additional calculations you need in the spreadsheet.

 

[Guest]

Hi Fred,
Thank you very much. It helped me.
I've one more question. I generated a report from a table. I changed the
field properties as those were not clear and visible. After that when I
export that report to an Excel file, some of the columns were interchanging!!
Like First column in the report will be the last but one column in the Excel
sheet. Only few colums were remaining the same.
Your prompt response is appreciated.