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

  • Thread starter Thread starter LarryP
  • Start date Start date
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.
 
Back
Top