Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Keep Formatting - Access to Excel

Discussion in 'Information Technology' started by hank755_ca@yahoo.ca, Jul 28, 2006.

  1. hank755_ca@yahoo.ca

    hank755_ca@yahoo.ca
    Expand Collapse
    Guest

    Hello,

    I have a report in Access which I want to export to Excel with the
    formatting intact. The formatting is rather complex with several
    headings and fields with borders. I have tried the "Analyze This"
    command but the formatting is totally lost.


    Is there a way I can save as much of the formatting as I can? Are their

    third party software that can do this?


    Thanks in advance
     
  2. Loading...


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    hank755_ca@yahoo.ca wrote:
    > Hello,
    >
    > I have a report in Access which I want to export to Excel with the
    > formatting intact. The formatting is rather complex with several
    > headings and fields with borders. I have tried the "Analyze This"
    > command but the formatting is totally lost.
    >
    >
    > Is there a way I can save as much of the formatting as I can? Are
    > their
    >
    > third party software that can do this?
    >
    >
    > Thanks in advance


    I don't think there is any way to do what you want, but I can think of a
    couple of ways that you might make it easier on the other end if you use the
    same format each time. Check over at the Excel NG.


    --
    Joseph Meehan

    Dia duit
     
  4. Craig Hornish

    Craig Hornish
    Expand Collapse
    Guest

    See my quote :)

    The way I would do it would take time and effort but it is possible.

    There may be a third part app to do this but I usually try to do things
    myself so the
    way I would do it is through "Automation". .

    You would directly control the process of exporting the data to the
    Excel sheet, and
    creating the formating.
    I won't go into a complete discusion
    but basically you set a reference to the Excel Object Library and then can
    use that to
    Open a Workbook, Set cell values and format the cells.

    If you decide to go this way I can show you an example of something I am
    developing.
    --
    Craig Hornish
    chornis at cap-associate.com

    Visit weekly Access conferences
    Tuesday, 11:00am-12:30pm (Eastern US)
    Thursday, 3:30pm- 5:00pm (Eastern US)

    http://community.compuserve.com/n/pfx/forum.aspx?webtag=ws-msdevapps

    "Think outside the box, because anything is possible."
    "How long it will take or whether it requires divine intervention is another
    issue"

    "Joseph Meehan" <sligojoe_Spamno@hotmail.com> wrote in message
    news:Jhxtg.25659$vl5.2499@tornado.ohiordc.rr.com...
    > hank755_ca@yahoo.ca wrote:
    >> Hello,
    >>
    >> I have a report in Access which I want to export to Excel with the
    >> formatting intact. The formatting is rather complex with several
    >> headings and fields with borders. I have tried the "Analyze This"
    >> command but the formatting is totally lost.
    >>
    >>
    >> Is there a way I can save as much of the formatting as I can? Are
    >> their
    >>
    >> third party software that can do this?
    >>
    >>
    >> Thanks in advance

    >
    > I don't think there is any way to do what you want, but I can think of
    > a couple of ways that you might make it easier on the other end if you use
    > the same format each time. Check over at the Excel NG.
    >
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
     
  5. Smartin

    Smartin
    Expand Collapse
    Guest

    Craig Hornish wrote:
    > See my quote :)
    >
    > The way I would do it would take time and effort but it is possible.
    >
    > There may be a third part app to do this but I usually try to do things
    > myself so the
    > way I would do it is through "Automation". .
    >
    > You would directly control the process of exporting the data to the
    > Excel sheet, and
    > creating the formating.
    > I won't go into a complete discusion
    > but basically you set a reference to the Excel Object Library and then can
    > use that to
    > Open a Workbook, Set cell values and format the cells.
    >
    > If you decide to go this way I can show you an example of something I am
    > developing.


    Hi Craig. I would be interested to learn more about what you are doing
    with Access-->Excel automation.

    Kind Regards,
    --
    Smartin
     

Share This Page