Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    38

    Question Unanswered: export to excel and column width

    Is there a way to keep the width of an Access table once exported to excel as I am finiding each time I export to excel the excel file does not adjust the column to the size of the text within the fields and I have to manually adjust the columns in excel to see all the data. Is there a way to do this without needing to manually do it - automation?

  2. #2
    Join Date
    Mar 2004
    Location
    Berlin, Germany
    Posts
    107
    there is a way but maybe try to use the autoformat option

  3. #3
    Join Date
    May 2004
    Posts
    38
    How do I use the autoformat option? I am using VB to transfer the table to excel can this still be done with that?

Posting Permissions

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