Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Export a Table to Excel (2003)

    The "Load XML" button on the startup form of the attached mdb is supposed to export the content of the Prezzix table to an Excel file but, try as I might, I just can't get the output Excel file to respect the neat ascending order of the Data(date) and Ora(hour) fields in the Prezzix table.
    How can I get the Excel file to comply?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Export a Table to Excel (2003)

    You may have tried a lot, but apparently you haven't tried the obvious: specifying the sort order:

    exportDataToExcel "SELECT * FROM Prezzix ORDER BY Data, Ora"

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export a Table to Excel (2003)

    I need to stick my head in a hole in the ground from time to time <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22> <img src=/S/bash.gif border=0 alt=bash width=35 height=39> <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30> <img src=/S/threadhead.gif border=0 alt=threadhead width=28 height=31> <img src=/S/newbrain.gif border=0 alt=newbrain width=21 height=22> <img src=/S/blowup.gif border=0 alt=blowup width=60 height=60>
    Thank you Hans <img src=/S/innocent.gif border=0 alt=innocent width=20 height=20> <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

Posting Permissions

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