Access-->XML-->Excel: Size Limitations?

LarryP

Guest

Posts: n/a

1st Dec 2009

I'm just starting to learn about exporting from MSAccess (2003) to XML, and
then opening the XML data file in Excel (2007). Have found that a file of
17000 records x 82 fields won't open in Excel, locks up the Excel app and
gives error messages that some data could not be imported. After bypassing
the error messages, result in Excel shows only the title row.

Anybody know if there's a size limit involved here? I'll post this over in
the Excel area too.

« How to Import/Export an OLAP Data Cube | Export Data from Report or Query to Excel »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
table size limitations in access	AMC	Microsoft Access	6	8th Sep 2004 12:11 AM
.csv / Excel size limitations	M	Microsoft Excel Misc	2	16th Feb 2004 01:24 PM
Access 2003 and size limitations	Heidi	Microsoft Access Getting Started	5	14th Dec 2003 02:39 AM
Access Database size limitations	Lisa Raimondo	Microsoft Access Getting Started	8	12th Oct 2003 12:55 PM
Access 97 MDB Size Limitations	Rene Duka	Microsoft Access	0	4th Aug 2003 10:41 PM