Hi All
Thanks for the contributions and apologies for the (very) late reply!. I was pulled into another project and have just come back to this. Its a very simple...

Thanks ModestyBlaise84 I will give this a try.

Hi Ian

It is a dBase IV file yes. When I tried to create a linked server I got an error message "IDBInitialize::Initialize returned 0x80004005".

I have similar results with an ODBC...

Hi John

Worked fine thanks, much appreciated!

PM

Hi All

Thanks for the replies. I was hoping I would not have to resort to creating a temp table but it looks like I will have to!