Adding fixed length data

[Crookshanks]

Hello,

I've got a small question regarding adding records with a fixed length. In an array i have several strings of 1024 chars each. It is the result of a flat textfile.

In tblFile I've got the format of the textfile worked out:
position 1-4 Code
position 5-50 Name
postition 51-90 Address
etc. (until 1024)...

Is there a trick to add a record without having to specify each field (comparable with the Do.cmd TransferText acImportFixed statement)?

Kinds regards,

 

[SgtJarrow]

You can do a "manual" import, defining all the import specs, and then save the specs near the end of the import process. The "saved" specs can be referenced during the DoCmd.TransferText call.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[Crookshanks]

Thanks for your answer. I did something like that!