Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 309
  • Last Modified:

MS Access DoCmd.TransferSpreadsheet - Export in 2003 or 2010

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
upobDaPlaya
Asked:
upobDaPlaya
2 Solutions
 
jerryb30Commented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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
 
upobDaPlayaAuthor Commented:
Great solution..thx
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now