Results 1 to 3 of 3

Thread: Maintain Font Format During Import

  1. 06-07-2010, 10:16 AM #1
    vcs1161
    vcs1161 is offline Registered User
    Join Date
    Aug 2009
    Posts
    7

    Question 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.
    Reply With Quote Reply With Quote
  2. 06-07-2010, 12:28 PM #2
    HiTechCoach's Avatar
    HiTechCoach
    HiTechCoach is offline Registered User
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    Quote Originally Posted by vcs1161 View Post
    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)
    Reply With Quote Reply With Quote
  3. 06-07-2010, 12:53 PM #3
    vcs1161
    vcs1161 is offline Registered User
    Join Date
    Aug 2009
    Posts
    7

    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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