Solved

MS Access DoCmd.TransferSpreadsheet - Export in 2003 or 2010

Posted on 2014-11-15
3
270 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now