Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro to Import Fixed Width Files

    I want to automate using a macro importing and exporting fixed width text files. Access Help is fairly straightforward with the exception of the section

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro to Import Fixed Width Files

    Hi Roberta,

    You'll need to manually import the text file once. When the Import Text File Wizard launches, you'll see an "Advanced..." button on the bottom left. Once you set the field widths, names, and data types, you can click the advanced button for more options - including the option to save the Spec.

    I believe this is a little easier than worrying about a Scheme.ini file (for most situations). Once you have the Spec saved, automation is fairly easy, either with a macro or code.

    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro to Import Fixed Width Files

    Thanks for this your a star!

Posting Permissions

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