Begin Transaction

[Taff07]

Hi,

Hopefully can help and knows a way to improve the efficiency of this method.

The Problem.
-------------

I am importing a data from a delimited text file. Due to the format of the data I have been forced to do this completely through VBA writing each record individually. This is fine most of the time but when it comes to larger files then the whole process slows completely.

I have used the BeginTrans/CommitTrans function but then trasnfer slows down the more records that have been processed. I assume this is to do with memory and cache etc that has been used throughout.

Can anyone point me in a direction to clear this if its the problem or shed some light and direction if it`s something completely different.

Thanks

Ian

 

[hermanlaksko]

When I import delim txt files I use the Import Wizard, in the wizard I make all the nessary ajustments, to get the best result. I then import the text into a buffertable if the text from the import is not to my liking (and this is the case, here as I understand it) when the text is in this table I then roll thou the data converting this and placing the converted data into the correct table. This method does the trick.

When using the wizard one is able to refer to this Import Specification i.e. DoCmd.TransferText A_IMPORTFIXED, "NNImport Specification", "BFC", File

Also if I run into files not called *.txt I copy the file to TheFileName.txt after the import I kill this file.

Hope this will move you in the corr dir.