Maintain Font Format and Color From Excel during Import

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?
 
K

Ken Snell

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keep Font format when importing excel into Access 1
Problem with MS Word paragraph and character styles: format getting messed up 2
color coding values 0
conditional format - table - cell empty return default color 1
Import errors from Excel 3
Count of Font Format 1
Import Excel 2010 table into Access 2010 - not listed as range 0
Conditional Format for font color using font color 2

Top