Hi thanks for your help.. I have attached a zip containing a control file and the same data file in .xls .txt and .csv. The control file has the relevant code to connect to all 3 data types I have got the .xls working like a dream thanks to your tweeks but the .txt and .csv I have no idea what im doing wrong. The .txt one is they most important.
It would be great if u could assit with .csv time permitting of course. Then I would have a good template for future and something I can share with fellow vba community.
Ideally code needs to connect to .txt and use the where statement sql
Reply With Quote