Results 1 to 2 of 2
  1. #1
    eladz949 is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2010
    Posts
    9

    export query to fixed width text

    hello im trying to export data in query to a fixed width text file. im using the access wizard and im defining what size each field should be, and total of 260 chars per tuple, but the output is a text file of 370 chars, anyone have a clue how to fix this?



    if i dont want to use the wizard, what is the command line for outputing data to text file of defined length??

    thanks a lot!!

  2. #2
    thhui is offline Competent Performer
    Windows XP Access 2002
    Join Date
    Feb 2009
    Posts
    235
    You have to use schema.ini to achieve this specification.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. export query to fixed width text
    By eladz949 in forum Import/Export Data
    Replies: 5
    Last Post: 01-01-2011, 03:28 PM
  2. Format decimal numbers with fixed width
    By Persist in forum Programming
    Replies: 5
    Last Post: 07-14-2010, 05:43 PM
  3. Replies: 5
    Last Post: 09-16-2009, 01:56 AM
  4. Formatting Fields and Fixed Width Exporting
    By Panman01 in forum Access
    Replies: 1
    Last Post: 05-22-2009, 09:32 AM
  5. Use fixed height and width for the Access window
    By AndrewAfresh in forum Access
    Replies: 3
    Last Post: 07-05-2006, 09:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums