Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel bulk transfer
Message
From
17/04/2009 12:06:31
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
17/04/2009 10:56:32
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01395271
Message ID:
01395293
Views:
75
>DBF files used to be a viable option for bulk transfer to Excel, i.e. transfer a large amount of data without the slow speed of setting each cell individually. The bulk transfer might be the first step; later, the Excel file is formatted with additional commands (e.g., column width, numeric format for individual columns, inserting additional header rows).
>
>Now, it seems that the DBF format is no longer supported by Excel 2007, so this can be a problem. What would be the recommended method for a bulk transfer from Visual FoxPro? Some other file format? Clipboard? Preferably a method that would work both with Excel 2003 and Excel 2007!
>
>Right now I don't have a pressing need to solve this; I was just wondering.


http://www.foxite.com/archives/0000153776.htm
http://www.foxite.com/archives/excel-automation-0000224361.htm

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