Solved

MS Access DoCmd.TransferSpreadsheet - Export in 2003 or 2010

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access 2016 - query 23 59
Reference theme colors in VBA 4 25
Access Date/Time to SQL Datetime2(7) 9 25
Calculate workdays and consider holidays database from microsoft 2007 8 22
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
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…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

776 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