SQL Data From Excel

  BWM 20:13 22 Jan 2008
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 2008

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.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?