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

Top