Solved

MS Access DoCmd.TransferSpreadsheet - Export in 2003 or 2010

Posted on 2014-11-15
3
281 Views
Last Modified: 2014-11-23
If a user has MS Excel 2010 I want to be able to transfer a MS Access query to MS Excel 2010.  If the user though has MS Excel 2003 I want the MS Access query to export to a MS Excel type of 2003.  What are your suggestion when exporting MS Access data to MS Excel when the users may have various versions of MS Excel ?
0
Comment
Question by:upobDaPlaya
3 Comments
 
LVL 26

Accepted Solution

by:
jerryb30 earned 250 total points
ID: 40445126
I would suggest least common denominator. Unless your query formats and exports cells so they contain capabilities only available to a certain version of excel, .xls works for a wide variety of versions. Does that not work for your users?
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 40446119
Ditto what Jerry said; generate an .XLS (2003 format) and let your later users install the compatibility pack so they can read .XLS or .XLSX.

Jim.
0
 

Author Closing Comment

by:upobDaPlaya
ID: 40461420
Great solution..thx
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

730 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