DBQuery on Excel Sheet - Numbers Ignored

dafe · Post by **dafe** » Thu Sep 11, 2008 9:02 am

I'm running the below macro on one of my excel spreadsheets. For some reason it is grabbing all the fields *except* for the fields that are just numbers.

As a test i did a MessageModal>StockSheet_10_13 which is one of the fields that stores a number. The resulting messagebox is blank. If I add a letter in front of the number in field _10_13 the message box displays the result perfectly.

Would anyone know the cause of this behaviour?

Code: Select all

Let>connStr=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\StockPOS\Test.xls;Extended Properties="Excel 8.0;Hdr=No;"
DBConnect>connStr,dbH

Let>SQL=select * from [Sheet1$]
DBQuery>dbH,SQL,StockSheet,nR,nF

DBClose>dbH

Let>StrResult=Start
Let>r=0
Repeat>r
  Let>r=r+1
  Let>f=0
  Repeat>f
    Let>f=f+1
    Let>this_field=StockSheet_%r%_%f%
    Concat>StrResult,this_field
  Until>f=nF
Until>r=nR

MessageModal>StrResult

Post by **Marcus Tettmar** » Thu Sep 11, 2008 9:11 am

You may have some mixed formats in the column. See this thread:
http://www.mjtnet.com/forum/viewtopic.php?p=20687

dafe · Post by **dafe** » Thu Sep 11, 2008 9:29 am

Thanks & sorry for reposting an already answered question

edauthier · Post by **edauthier** » Thu Oct 02, 2008 9:29 pm

Check out this thread...

http://www.mjtnet.com/forum/viewtopic.p ... highlight=