ianmtl
asked on
How do I have an Accesss output to Excel 2010 instead of Excel 2007
I have both MS Office 2007 and MS Office 2010 installed on my PC. I am working in Access and my D/B is quite large. If I want to have the table in Access output to Excel, I need it to go to Excel 2010 due the size of the D/B. Excel 2007 limits me to 65K rows as Excel 2010 can handle over a million rows.
Any help would be greatly appreciated.
Thank You
Any help would be greatly appreciated.
Thank You
ASKER
I need to know how to get the export to go to Excel 2010 not Excel 2007, which seems to be the default. I have no problems in exporting to Excel 2007. As noted in my question I have both versions of ofice on my PC
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In any event, you should be able to use either:DoCmd.OutputTo acOutputTable, "NameOfTable", acFormatXLSX, "C:\folder\subfolder\Expor t.xlsx"orD oCmd.Trans ferSpreads heet acExport, acSpreadsheetTypeExcel12Xm l, "NameOfTable", "C:\folder\subfolder\Expor t.xlsx"
<No points wanted>
With:
DoCmd.OutputTo
...you can tell Excel to Open the Excel file just created, immediately after the export.
DoCmd.OutputTo acOutputTable, "NameOfTable", acFormatXLSX, "C:\folder\subfolder\Expor t.xlsx",Tr ue
;-)
JeffCoachman
With:
DoCmd.OutputTo
...you can tell Excel to Open the Excel file just created, immediately after the export.
DoCmd.OutputTo acOutputTable, "NameOfTable", acFormatXLSX, "C:\folder\subfolder\Expor
;-)
JeffCoachman
http://databases.about.com/od/tutorials/ht/export_2007_excel.htm