Thanks again RS fore the help you have given me.

I'm still struggeling with your code trying to understand it all but it will take some time before I do. So I'm pleased that SQL and ADO metode are slower since I have much less chance of understanding that. But it was very kind of you to spend time and effort on my behalf.

I had a look at link you gave me and realised that this is way above my present VB knowledge.

In your code you declaired a variabel:

Dim strSep As String

I can't see any reson fore it and the macro runs fine without it. I guess you used this macro before and modified it to suit my needs. So strSep is a variabel not needed im my case or??