Link to home
Start Free TrialLog in
Avatar of mlagrange
mlagrangeFlag for United States of America

asked on

TransferSpreadsheet in Access 2010

Hello - I'm working in an mdb (created in Access 2003) using Access 2010.

I need to export a table to Excel 2010 (.xlsx), and I see that the SpreadSheetType enumerators displayed by the IntelliSense only go out to "SpreadSheetTypeExcel9", which I found out is Excel 2000.

Can someone point me to the enumerators for the various types for Excel 2007/2010?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mlagrange

ASKER

That works!  

Thanks again, Cap