Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page