sql - Import XML to Excel 2013 - file size limits? -

i tried import >300mb xml file , fails though few thousand rows!

is there maximum processing time or file size?

the same kind of data in 10mb portion works well. access takes longer on 10mb portion , splits in different tables don't make sense, perfect stay excel (with xml redundancy removed text in spreadsheet may 10% size).

i able set (linux) server solution of course, better! writing xquery script frustrated me since runs slow , wasn't worth work simple conversion automated.

from: https://support.office.com/en-us/article/excel-specifications-and-limits-ca36e2dc-1f09-4620-b726-67c00b05040f applies excel 2016, excel 2013.

feature maximum limit

worksheet , workbook specifications , limits

open workbooks                    limited available memory , system resources                                           worksheet size                    1,048,576 rows 16,384 columns column width                      255 characters row height                        409 points page breaks                       1,026 horizontal , vertical total number of characters   cell can contain           32,767 characters characters in header or footer  255 sheets in workbook              limited available memory (default 1 sheet)                                           colors in workbook              16 million colors (32 bit full access                                   24 bit color spectrum) named views in workbook         limited available memory unique cell formats/cell styles   64,000 fill styles                       256 line weight , styles            256 unique font types                 1,024 global fonts available use;                                   512 per workbook number formats in workbook      between 200 , 250, depending on language                                    version of excel have installed names in workbook               limited available memory windows in workbook             limited available memory hyperlinks in worksheet         66,530 hyperlinks panes in window                 4 linked sheets                     limited available memory scenarios                         limited available memory; summary report                                     shows first 251 scenarios changing cells in scenario      32 adjustable cells in solver        200 custom functions                  limited available memory zoom range                        10 percent 400 percent reports                           limited available memory sort references                   64 in single sort; unlimited when using                                   sequential sorts undo levels                       100 fields in data form             32 workbook parameters               255 parameters per workbook items displayed in filter drop-down lists                   10,000 noncontiguous cells   can selected              2,147,483,648 cells maximum limits of memory storage   , file size data model   workbooks                         32-bit environment subject 2 gigabytes (gb)                                     of virtual address space, shared excel,                                     workbook, , add-ins run in same process.                                     data model’s share of address space might run                                     500 – 700 megabytes (mb), less                                     if other data models , add-ins loaded.                                   64-bit environment imposes no hard limits on file                                     size. workbook size limited available                                     memory , system resources. 

calculation specifications , limits

number precision                  15 digits smallest allowed negative number  -2.2251e-308 smallest allowed positive number  2.2251e-308 largest allowed positive number   9.99999999999999e+307 largest allowed negative number   -9.99999999999999e+307 largest allowed positive number   via formula                       1.7976931348623158e+308 largest allowed negative number   via formula                       -1.7976931348623158e+308 length of formula contents        8,192 characters internal length of formula        16,384 bytes iterations                        32,767 worksheet arrays                  limited available memory selected ranges                   2,048 arguments in function           255 nested levels of functions        64 user defined function categories  255 number of available worksheet   functions                         341 size of operand stack         1,024 cross-worksheet dependency        64,000 worksheets can refer other sheets cross-worksheet array formula   dependency                        limited available memory area dependency                   limited available memory area dependency per worksheet     limited available memory dependency on single cell       4 billion formulas can depend on single cell linked cell content length   closed workbooks             32,767 earliest date allowed   calculation                       january 1, 1900 (january 1, 1904, if 1904 date                                     system used) latest date allowed   calculation                       december 31, 9999 largest amount of time   can entered                    9999:59:59 

charting specifications , limits

charts linked worksheet      limited available memory worksheets referred chart 255 data series in 1 chart          255 data points in data series   2-d charts                    limited available memory data points in data series   3-d charts                    limited available memory data points data series   in 1 chart                      limited available memory   

pivottable , pivotchart report specifications , limits

pivottable reports on sheet     limited available memory unique items per field            1,048,576 row or column fields in   pivottable report                 limited available memory report filters in pivottable   report                            256 (may limited available memory) value fields in pivottable   report                            256 calculated item formulas in   pivottable report                  limited available memory report filters in pivotchart   report                             256 (may limited available memory) value fields in pivotchart   report                             256 calculated item formulas in   pivotchart report                  limited available memory length of mdx name   pivottable item                    32,767 length relational   pivottable string                  32,767 items displayed in filter   drop-down lists                    10,000 

shared workbook specifications , limits

users can open , share   shared workbook @ same time    256 personal views in shared workbook limited available memory days change history   maintained                          32,767 (default 30 days) workbooks can merged   @ 1 time                         limited available memory cells can highlighted   in shared workbook                32,767 colors used identify changes   made different users when change   highlighting turned on           32 (each user identified separate color;                                       changes made current user highlighted                                       navy blue) excel tables in shared workbook   0 (zero)