SQL Data From Excel

  BWM 20:13 22 Jan 08
Locked

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Prehistoric Britain is laid out in these Royal Mail stamp illustrations

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…