Hi Jackie,

No masking or formatting that I can see. Very weird!!

Thanks Perry,

Still doesn't work though.

Mike

I'm using ADP and the data source is a query.

Great Peter! That works fine

Thanks Peter,

But now I get the error:

Server: Msg 7357, Level 16, State 2, Line 1

Could not process object 'SELECT * FROM [Sheet1$]'. The OLE DB provider 'Microsoft.Jet.OLEDB.4.0' indicates that the...

Thanks Jonathan. So there's nothing in the SELECT statement that allows results to be saved direct to a CSV file.

Thanks Peter. That worked great!

Thank you Peter. I shall try this tomorrow.

Mike