Import Fixed Length Text File

[Guest]

I need to import a fixed length text file into Access so
that I can "map" it into a new .csv file. Can anybody
offer me some suggestions on how to import a fixed length
file and retain the proper character lengths/field?

Thanks, Marc

 

[Guest]

OK, I figured out that i can simply create a macro to
import it using the 'fixed width' type. Now the real
question is how do i create a specification for it - how
should it read? i understand that it is the file that
access will look to for field lengths, etc, but i have no
idea what it should look like! i believe it should
be "schema.ini"...

Please Help!!

 

[Mike Painter]

OK, I figured out that i can simply create a macro to
import it using the 'fixed width' type. Now the real
question is how do i create a specification for it - how
should it read? i understand that it is the file that
access will look to for field lengths, etc, but i have no
idea what it should look like! i believe it should
be "schema.ini"...

Please Help!!

Click on the advanced button when you are just about done with the import.
Save the specification with a good name and use that in your Do.Cmd transfer
text.
You can do the same thing for your csv export routine.