-
Maintain Font Format During Import
Is there a way to maintain the font format from Excel into Access? We are changing some type within a cell to red font and underlining but that does not come with when we import that excel worksheet into Access.
-
Originally Posted by vcs1161
Is there a way to maintain the font format from Excel into Access? We are changing some type within a cell to red font and underlining but that does not come with when we import that excel worksheet into Access.
What version of Access are you using?
How are you import? Excel Automation or something else?
TIP: The more specific you are the quicker we can help
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC]
Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
-
Access 2003
I am using Access 2003. This would be a macro that will use the Transfer Spreadsheet action and Import Transfer Type from an Excel file given a directory path and will import/append into a system table within the Access database.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|