Maintain Font Format and Color From Excel during Import

  • Thread starter Thread starter garvic82
  • Start date Start date
G

garvic82

We have an excel spreadsheet that is updated by changing select text to red
and highlighting in a text cell. So there are only certain strings where the
format is changed and the rest stays as the default format. This select
formatting does not carry over when it is imported into an Access database.
Is there a way to keep the text format during this process?
 
No. ACCESS does not allow you to have different formats in standard data
fields. (ACCESS 2007 allows you to use a richtext data type, which does
allow different formatting, but importing won't automatically bring over the
format from EXCEL.)
 
Back
Top