I am using a spreadsheet (v2000) as a database table and pulling data from it using a VBA SQL string into another Excel workbook (Select * from DataTable). It works fine unless a column has both numeric and text data in different cells. Then it only returns either the numeric data or the text and leaves the other cells in the column empty. It will not give both. It seems to work in Excel 2007 so it seems like it is a bug in 2000. Does any one know a way around this please?