I am sure most people understand you can not have mixed types in a spreadsheet and read the data with ado. Does anyone know of a solution for this without using ole? I have clients importing excel data and I can not control the mixed type issue. Using ole on the server has caused the server to go down from time to time. I really have not been able to find another solution under these parameters. Thanks for your help.