Export text, excel imports as a number

  • Thread starter Thread starter AP_CAN
  • Start date Start date
A

AP_CAN

From an Access report, I "Analyze it with MS Excel". It
exports text fields as numbers. For example I export
020405672, but excel imports it as 20405672. The field is
text in the table as well as the report. How do I prevent
it from dropping the preceeding zero?
 
-----Original Message-----
From an Access report, I "Analyze it with MS Excel". It
exports text fields as numbers. For example I export
020405672, but excel imports it as 20405672. The field is
text in the table as well as the report. How do I prevent
it from dropping the preceeding zero?
.
Are you doing this manually, or do you have an Export
Specification? If manually, when you do your export, I
would export out of access with commas (,) between fields
and quotes (") around text fields. Then when you import
the file into Excel, you don't loose any of your
preceeding zeros.
 
You can force Excel to treat them as text by prepending an apostrophe,
e.g.
'020405672
by using calculated fields in the query underlying the report or
modifying the controlsource of the textboxes in the report to something
like
="'" & [FieldName]
 
-----Original Message-----

Specification? If manually, when you do your export, I
would export out of access with commas (,) between fields
and quotes (") around text fields. Then when you import
the file into Excel, you don't loose any of your
preceeding zeros.
.
Would this work with Linking? I am collecting
information from other spreadsheets and combining onto
one spreadsheet. I then Link from Access.
 
Back
Top