how to gain speed

[PF]

thanks for the answer

I think in my case the parsing is the best,
what i want to know is when it comes to add data in access

is there something faster than rst.addnew (add to a recordset)

is there a way to insert say 1000 records in one insert?

Before i was generating a flat text file then import the text file.

Now i don't generate the textfile since i build the tables in access
directly
while normalising them using seek to find already transfer data etc...
It is long and i would like improving the speed.

regards

pf