Excel Extract from SQL Table Editor
Hi Team,
Is there any way to extract the SQL Table Editor to an Excel File?
Currently I have a SQL table editor with multiple pages and the default extract method by right clicking on the co...
Forum Discussion
I would use a TableView to pull the data from the underlying table directly into an embedded spreadsheet, from which you can save as an offline .xlsx file. The GolfStream application has some examples of TableViews.
GridViews of course (as mentioned above) are another option, however they may take a long time to display if you have a large set of data. You can right-click and export to an Excel XML , which you can load to Excel.
Where possible I would avoid using any methods that convert data to text or CSV as an interim step towards Excel, because that messes up regional differences in number formats, date format assumptions, delimiter characters etc.
Hey Chris
We have tried extracting the Table using Spreadsheet Rule and TableViews but then we are facing this error when we are refreshing the table view.
any idea on this where how can we increase the memory allocation size of the Table View?