fixed width

  1. M

    Array to Text Output

    Ok, I have string array with values that have leading or trailing spaces or zeros to make the values correct for a fixed width file. Does anyone know and easy way to export the array as a text file with no formatting so it will be a proper fixed width text file? Thanks, Matt
  2. P

    String Parsing Guidance

    Hi All I was wondering if all you nice Access Gurus could provide me with some guidance. I am used to working with comma deliminated text files and parsing them into a table. However I am now getting Fixed width datafiles and the Person's name for each record is no longer comma delminated...
  3. K

    can I Import Multiple Fixed Width Files at once

    Is it possible to import multiple fixed with files at once? I can make the following work, but I do not know how to allow the user to search for a file. Sub OpenTextFile() Const xlFixedWidth = 2 <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Set...

Some videos you may like

This Week's Hot Topics