Had a module before that was using Excel 2000 and ado to connect to SQL Server. Was not sure if that would work using excel 97 so thought I revert back to DAO which I was sure I could use.

Pain in the arse.

Tried ADO - Nay bother, as they say in Scotland

All the best big man