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