Results 1 to 2 of 2

Thread: ADO and EXCEL

  1. #1
    Ross Carr Guest

    Default ADO and EXCEL

    I am using ADO to access a named range within excel. This works fine with the following exceptions:<BR> I have a "field" that contains entries such as 1.6, 1.4d, 3.2 etc. The queries pick up the true text entries (ie 1.6 etc) but ignore the entries that are numeric.<BR> I have another field which is either blank or contains a number. The queries return records containing both of these. However all fields are shown as blank.<BR>Can someone help ?<BR>I have set the cell format to be text, but this seems to make little difference.<BR>Does anybody know whether as part of the ado connection, you can specify the data type ?<BR><BR>Regards<BR>Ross

  2. #2
    Join Date
    Dec 1969

    Default RE: ADO and EXCEL

    This excellent article answers your Q:<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts