export a MS ACCESS Report to Excel (1 Viewer)

[ptquan]

Folks,

I have a TEXT field in a report which contents "0" at begin (ex. 01234). When export the Report to excel file, the digit "0" deleted automatically.

Is there any solution to solve this issue?

Thanks to advise, Folks.

//Quan

 

[rodmc]

Folks,

I have a TEXT field in a report which contents "0" at begin (ex. 01234). When export the Report to excel file, the digit "0" deleted automatically.

Is there any solution to solve this issue?

Thanks to advise, Folks.

//Quan

you can either pre-format the spreadsheet to treat that column as general text, or you can prefix the data in access before you export it to excel with '

 

[Meehphill]

thank you everyone