export a MS ACCESS Report to Excel

ptquan

Registered User.
Local time
Today, 10:27
Joined
May 9, 2013
Messages
12
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
 
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 '
 
thank you everyone
 

Users who are viewing this thread

Back
Top Bottom