Speed up my loop!

[davesmith202]

I'm wondering if the whole process of trying to import my data line by line from a text file is like leaning my ladder against the wrong wall.

Banana mentioned using a Query, although my sql is too weak to work out what to do. But it kind of makes sense since Access is optimized for fast running of Queries.

Also, I have read this: http://www.bigresource.com/VB-Import-Large-Text-File-to-Access-Db-yWSlsPsDrP.html

It seems to suggest you can import large text files fast. So perhaps I should import the file into a table and then process it from there, rather than using an array?

I'm a bit lost on what to do.

By the way, I did double the speed by disabling my text counter code: Me.txtCount1 = CStr(x)

But now I don't see any progress and have no idea when it would finish. Can I only update the counter every 1000 loops or so? Would I need to use Mod somehow?

 

[DCrake]

You could try passing the counter to a label instead of a textbox using the caption. This may quicker than the textbox option.