>I am gathering data from an Excel 2010 workbook into VFP 9 SP2 using ODBC via SQLSTRINGCONNECT(). The cursor created by SQLEXEC() creates two columns of data (among many other columns) that should be of the same data type, but one is coming into VFP as data type "B" (double) and the other as data type "M" (Memo). The double field is causing me to loose the character data that also resides in the column.
>
>When I look at the data with Excel, the cells in both columns are General fields. The first record contains column headers that start with letters ("Pin1" and "Pin2"). I have tried changing the data in the second record from numeric to alpha but it doesn't seem to make any difference.
>
>My assumption is that the problem is somewhere in the Excel file, but I can't see where there is any difference between the two columns.
>
>Any ideas?
>
>Thank you for your time.
>
>Steve
What happens if you add a ' at the very first cell in the column that converts to wrong format?
If it's not broken, fix it until it is.
My Blog