Topics Search

Export to Excel 2007

Export to Excel 2007
Views: 5
I'm using the code below to export a large data set from Access 2007 to Excel 2007. My code works fine exporting to Excel 2003 but I need it to be in 2007 due to the file's size. Everytime I try to export to an xlsx extension I get an error saying the extension is invalid or the file is corrupt.

Sub ExportSuppliersAllExcel()
Dim oXLApp As Object
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "dm_DBTR", "C:\Users\aoconnell.RAUC\Documents\dm_DBTR.xls", True
Set oXLApp = CreateObject("Excel.Application")
oXLApp.workbooks.Open "C:\Users\aoconnell.RAUCH\Documents\dm_DBTR.xls" oXLApp.Visible = True
Exit Sub
End Sub
Sponsored Links:

Similar posts...

 

Access to Excel 2007 export annoyance

Access to Excel 2007 export annoyance Icon
I've globally disabled the "Always create backup" general option for Excel 2007, but this only works when I start up from Excel. When I export to Excel 2007 within Access 2007, which I do very frequently, the resulting spreadsheet has this (quite annoying and unnecessary feature for me, anyway) turned back on. I can export to .xls without this issue, but prefer the more compact .xlsx format.

Anyone have a fix for this
 

Access 2007 report to Excel 2007. Keeps forcing me to choose Excel 2003?

Access 2007 report to Excel 2007. Keeps forcing me to choose Excel 2003? Icon
I am having trouble export and Access 2007 report to Excel 2007. When I click export to excel it is only allowing me to export to excel 2003 or lower. The reason this is an issue is my report is over 64K of data.
 

Docmd.Transferspreadsheet from Access 2007 to Excel 2007 .xlsm

Docmd.Transferspreadsheet from Access 2007 to Excel 2007 .xlsm Icon
Trying to export a Access query to an Excel file like I've done hundreds of times with previous versions.

Simply put, I want to export a query from Access 2007 to Excel 2007 to a .xlsm file.

When I have a query open and click [External Data]>[export to Excel] the xlsm file format is not even in the list.
 

How to export an Access 2007 report to Excel via VBA

How to export an Access 2007 report to Excel via VBA Icon
And it's unclear if they're for 2003 or 2007.

I've got a report in Access 2007 that I would like to be able to export to Excel using VBA.
The ribbon already has an option to export to Excel, which does everything I want, but the ribbon gets disabled as one of my security protocols, so the users are blocked from using the export options here.

Is there a way to call this feature from VBA/Allow this on a custom built ribbon/do something similar via VBA?

I've looked into using the TransferSpreadsheet method, but the query for my report is a rather big union query, based on a filter form, and is too complex for the TransferSpreadsheet method to use.
 

Export to Excel continues to run for hours and fail

Export to Excel continues to run for hours and fail Icon
I am trying to export a query out of Access 2007 and into excel. When I run my export, it continues to run for hours without exporting the file.

On average, the query returns 30k-60k records so I am dumbfounded as to why it will not export.
 

Export To Excel, Access 2010

Export To Excel, Access 2010 Icon
I need to export a query to excel , the query comes from a big table but it's filter out by a pre selection date I picked but when it export to excel everything will be come in to excel, & I need only a part of it.

IS there a way to export to excel only what is displayed on the Query & not on what is hard coded
 

Access 2007 - Export report to Excel

Access 2007 - Export report to Excel Icon
I have some reports that I export to Excel. If the heading is one word, the heading shows in Excel but if it is a heading like, "Membership with 2 or more Products," then all that appears is Text14 for example. Is there anyway to get the heading to show in Excel?
 

VBA to export pivot table as export to excel option

VBA to export pivot table as export to excel option Icon
Is there vba code to obtain the same result that “Export to Excel” button on ribbon/toolbar access menu? I tried to use DoCmd.OutputTo command but only data refer to recordsource control was export in excel file. I mean there is a difference between the action that the "Export to Excel" execute from the action that execute the use of DoCmd.OutPutTo
 

Export Single Record

Export Single Record Icon
Is there a way to export a single record from an Access 2007 form? It can be exported to Excel or as a PDF or text file. For example if my data source has 100 records I just want to export record 5. If I need to explain this further just let me know.
 

How do I export an Access table as an Outlook contact group w/o first using Excel?

How do I export an Access table as an Outlook contact group w/o first using Excel? Icon
I have an Access 2007 SQL database with 20 users. The DB has a list of about 3,000 email addresses that I want to export to Outlook for mass mailing. I've already got the services of anSMTP mail service that allows 1000 mails at a pop to be sent, and I've already written in the logic to separate the list into groups of 1k.

The problem I'm having is that I'm currently exporting from Access 2007 to Excel 2003 format (for some unknown reason Outlook 2007 does not directly interface with Access 2007), and then I have to manually go through the import steps within Outlook to bring the data from each 1k name group spreadsheet into a contact group for mailing.