Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007

    Unanswered: maintaining color in access tables

    hello friends !!

    i import excel sheet into access table with colored cell values
    and make some changes in access and then export to the new excel sheet

    but when i export from access to excel sheet then i just get excel sheets without color'd cells

    so is there any way to maintain colors when imported into access and then retrive the same color'd cells when exported from access to excel

    any ideas would be appreciated !!

  2. #2
    Join Date
    Feb 2007
    you could link the table rather than importing it.

  3. #3
    Join Date
    Jan 2007
    Provided Answers: 12
    When you link to Excel you link to the DATA in the spreadsheet.
    Colour is therefore not included.

    Do as Strakmann suggests or you might even be able to utilise pootle flumps Excel Automation stuff in the MS Access code Bank (which can be found in a sticky at the top of the access topic (on the first 2 pages somewhere methinks)). Anyhow, if there arespecial rules for colouring then no doubt you'll be able to bodge something together with that. But beware, it's not going to be easy!

    Good luck
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts