Access Exporting help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • SouthernCross
    New Member
    • Jun 2006
    • 1

    Access Exporting help

    I am trying to export a large Access database I have into Excel but there are too many fields for it to correctly export into Excel. Is there anyway to have Access export the data in an inversed sort of form where the field name and field value are horizontally represented (ex. Field Name| Field Value) rather than vertically represented? Any help would be much appreciated. Thanks!!
  • wlc04
    New Member
    • May 2006
    • 70

    #2
    You could try to export it to a delimited text file and use some vb code from excel to move the data into a "horizontal presentation".

    Comment

    Working...