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

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? I'll post this over in
the Excel area too.
 

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: File size issue??? 0
Microsoft Project - error opening exported XML file 0
Importing XML Data in Access 2003 1
Export to XML - error 31532 0
Access 2007 - Export to XML 1
import XML data...Is there a size limit on the import? 0
Connection/Refresh Control unavailable for imported XML data 0
Excel/XML File Limitations 2

Top