Versions des environnements
Network:
Windows 2003 Server
>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.
Excel 10...
I usually append from xl5 into a cursor pre-created to my definitions.
AFAIR saving to Excel can be done via automation, in my work I do this often by hand...
If you have oodles of sheets, import into memo always and program from there.
HTH
thomas
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement