General information
Category:
Coding, syntax & commands
Title:
Save Large Tables in Excel Format
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only