If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Keep Font format when importing excel into Access
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? |
#2
|
|||
|
|||
Keep Font format when importing excel into Access
When working with Access, you would want to recreate the formatting criteria
in the reports or forms. The tables in Access only show raw data and do not do any calculations or anything. If you wondering how to recreate the formating condtions in Access you might need to ask the question over in that form. I hope this helped. "garvic82" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|