Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Save Large Tables in Excel Format
Message
From
01/07/2005 17:01:47
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
01/07/2005 10:59:08
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01028183
Message ID:
01028361
Views:
10
>Hi
>
>I am wanting to save the contents of a large table onto a spreadsheet but have hit the problem where there is a limit of 16383 on the number of rows that are allowed.
>
>I have tried saving as a csv file and opening in excel. This does get all the records but they are not formatted correctly. I want each column to represent a field on the table but this metohd gives me the whole record in column 1.
>
>Is there any other way of outputting the table. I am aware that one alternative is to split the records so that more than one spreadsheet is produced and these can then be pulled together.
>
>I was hoping there might be a way to just produce the one spreadsheet in the correct format.
>
>Anybody got any suggestions?
>
>Sue

Check Message #779111, Message #826728 and especially Message #993947
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