Full Version: Upgrading To A2010 From A2003
UtterAccess Discussion Forums > Microsoft® Access > Access Automation
jabez
Mar 29 2012, 07:08 PM
I am upgrading my app from A2003/Office2003/WinXP to A2010/Office2010/Win7 - the client is upgrading their IT environment. I did the auto conversion from mdb to accdb ... and am now testing the various parts of the app. Everything seems to be working just fine. Except: in my old code I have this line:

CODE
DoCmd.OutputTo acOutputQuery, "QExportPtData2", acSpreadsheetTypeExcel9, stPath & FilePatients, True


... to export the results of query "QExportPtData2" to an Excel spreadsheet. When I try to run this now, A2010 says "the format in which you are attempting to output the current object is not available".

Any help to fix this is much appreciated!

J
theDBguy
Mar 29 2012, 09:09 PM
Hi J,

Try replacing the format constant with "acFormatXLS."

Just my 2 cents... 2cents.gif
jabez
Apr 3 2012, 10:25 PM
Hi DBguy ... thanks! It works like a dream!
theDBguy
Apr 3 2012, 10:26 PM
Hi,

yw.gif

Glad to hear it worked! Good luck with your project.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.