Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Boston, Massachusetts, USA
    Posts
    205
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Another Export to Report Question (Access 2002)

    I have another client that is insistent on something that is rather illogical, which means I must reinvent the wheel. Or maybe not. . .
    Is it possible to export a report in tab delimited format and keep the header and footer information?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Another Export to Report Question (Access 2002)

    Select the report, use File | Export and in the Save as Type enter TextFiles (*.txt;*.cvs;....)
    In VBA use
    DoCmd.OutputTo acOutputReport,"ReportName",acFormatTXT, "NameOfFile.txt",False
    Francois

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Another Export to Report Question (Access 2002)

    Francois is correct, but if you have any graphic objects in your report (charts, bit maps, etc.) they will be lost. I'm also not sure about how subreports get handled. If you really want something pretty, you could try automation to Word. Hope this helps.
    Wendell

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Boston, Massachusetts, USA
    Posts
    205
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Another Export to Report Question (Access 2002)

    Thank you both for your suggestions. The data has no sub-reports or graphics. It is very straight forward no nonsense stuff.

    However, doing it the way the two of you suggest does not preserve the headers and/or make it Tab delimited.

    Alternatively, if there is a character we can insert between the fields that the Excel Text Import Wizard would recognize as a tab, that would work splendidly. Any further ideas?

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Another Export to Report Question (Access 2002)

    I think what you are probably after is to export it to an RTF format. That uses tabs and what not to format it as closely as possible to the report. Or are we dealing with a report here - unfortunately I can't test the 2002 export as the system I'm on today doesn't have it installed, but I thought headers and footers were always exported from a report. You mentioned Excel, and it possible to export the data source for your report directly to Excel, or you can export the data source as a text file that is tab delimited (or any other character you want to specify).
    Wendell

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Another Export to Report Question (Access 2002)

    To get a tab delimited file, you need to export it to a Word merge format. No export to straight text or tab delimited is going to preserve headers, though.
    Charlotte

  7. #7
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Another Export to Report Question (Access 2002)

    Well, I just tried it on the system in my office that runs XP, and it did export the headers to a text file. That particular report doesn't have grouping headers, but it does have a Report Header and Page Headers and Footers. However it isn't at all pretty, and in some cases lines have to wrap, etc. In addition pagination is likely not to be preserved. Therefore I think you'll find the RTF version a better choice.

    Just to be clear, the process I used was to expose the Database Container Window, select the Reports tab, and then right click on the name of the report I wanted to export. I then chose the Export menu, and a dialog box popped up asking what I want to export to, and I selected the choice .txt, .csv, .asc .... I then got a prompt asking what character code I wanted (Windows, DOS and 2 Unicode choices) and I took the default of Windows. We may be able to be of more help if you explain what you want to do with the report once you get it to Word or Excel.
    Wendell

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Boston, Massachusetts, USA
    Posts
    205
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Another Export to Report Question (Access 2002)

    Thank you for your help. I found out that they are using Access 97 instead of XP, which certainly explains a lot. I know you might be more help if I could explain more. Knowing where the data is going to end up or how it is going to be used once it is exported would be a grand help indeed. Sadly, I'm still trying to find that out myself. So, for now, you know as much as I know.

  9. #9
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Another Export to Report Question (Access 2002)

    A very common story when doing things for other folks - often times the digging <img src=/S/confused.gif border=0 alt=confused width=15 height=20> <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29> <img src=/S/thinks.gif border=0 alt=thinks width=15 height=15> for how things really are is more effort than resolving the situation.
    Wendell

Posting Permissions

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