?
Solved

How do I have an Accesss output to Excel 2010 instead of Excel 2007

Posted on 2010-08-26
5
Medium Priority
?
556 Views
Last Modified: 2013-11-29
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
0
Comment
Question by:ianmtl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 8

Expert Comment

by:Pramod Bugudai
ID: 33534708
0
 

Author Comment

by:ianmtl
ID: 33534807
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
0
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 2000 total points
ID: 33535380
>>Excel 2007 limits me to 65K rows Not true.If you are using the xlsx or xlsm file formats in Excel 2007, you get the same number of rows and columns (~1 MM rows by ~16 K columns) as in Excel 2010.
0
 
LVL 93

Expert Comment

by:Patrick Matthews
ID: 33535653
In any event, you should be able to use either:DoCmd.OutputTo acOutputTable, "NameOfTable", acFormatXLSX, "C:\folder\subfolder\Export.xlsx"orDoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "NameOfTable", "C:\folder\subfolder\Export.xlsx"
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33536070
<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\Export.xlsx",True


;-)

JeffCoachman
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question