Access-->XML-->Excel: File size issue???

L

LarryP

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access-->XML-->Excel: Size Limitations? 0
import XML data...Is there a size limit on the import? 0
xml import....Size limit?? Can the XML file be split?? 0
xml import problem 0
Excel/XML File Limitations 2
XML File IMport to Excel 0
Converting Large XML Files into CSV File via Excel 2
Excel 2007 export as XML size limit/bug 0

Top