Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fast data transfer into Excel avoiding date problems
Message
From
21/07/2003 04:01:52
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00805939
Message ID:
00811933
Views:
15
>> Nope, ADO is available to Excel97 too.
>> Cetin
>
>I have other other solution working well as described in my other thread, however, I might migrate to ADO in the future.
>
>Do you think the performance using ADO will match bringing in 6 million values into Excel as a .CSV file (which is very fast)?
>
>Thanks,
>Jeff

I don't know, never tried with 6 million values. But should be, with over 3 million values it takes few secs on my Athlon 650, 192Mb system.
.CSV has the advantage of being a natively recognized format in Excel. If you can do with .csv than use .csv.
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
Reply
Map
View

Click here to load this message in the networking platform