COPY TO xxxx.xls TYPE XLS (VFP 8.0 SP1)

Posted by Andrea.Ko on Stack Overflow See other posts from Stack Overflow or by Andrea.Ko
Published on 2010-04-29T05:12:06Z Indexed on 2010/04/29 5:17 UTC
Read the original article Hit count: 616

Filed under:

Hi All,

I downloading table from SQL 2008 using VFP 8.0 (SP1) using command: COPY TO xxx TYPE XLS Some of the data in the excel is disappearing.

Example, Table in SQL: Cus(ID int(4), CusNam VARCHAR(35))

When i issue the following command at VFP Forms:

(a) COPY TO xxx TYPE FOX2x [Data display correctly as following]

*ID CusNam

1 ABC

2 DEF*

(b) COPY TO xxx TYPE XLS [2nd Record disappear]

*ID CusNam

1

2 DEF*

Appreciate for any helps!

© Stack Overflow or respective owner

Related posts about vfp