The CSV seems the appropriate solution. After outputting to CSV, open the file in Excel, and do any desired formatting changes. This can be automated from VFP.
>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
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
