Solved

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

Posted on 2010-08-26
5
548 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 92

Accepted Solution

by:
Patrick Matthews earned 500 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 92

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

687 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