SQL Data From Excel

  BWM 20:13 22 Jan 08

I am using an Excel 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?

  VoG II 22:54 22 Jan 08

With apologies to any members of this forum that might know the answer I suggest that you post your question at click here

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5