Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy but of 16384 rows
Message
From
28/12/2000 13:42:31
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00457281
Message ID:
00457469
Views:
19
>How I can copy but of 16384 rows of a table to a worksheet of Excel 2000?
>I do the following thing:
>
COPY TO MyFile TYPE XL5
>and only copies 16384 rows to me that are limits of Excel 95.
>
>I now execute
>
COPY TO MyTable TYPE FOX2X
>and I open from Excel like a DBF file and cuts the fields DATETIME.
>
>Work with VFP6 (SP4) in Spanish.
>
>Sorry, my English is bad. My main language is Spanish.

Check Thread #422500
There fox2x is used but fox2x doesn't support datetime values. Instead you could use CSV, delimited.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform