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