INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

DoCmd.TransferSpreadsheet problem

DoCmd.TransferSpreadsheet problem

(OP)
I have a fe/be 2003 database that was able to use the docmd.transferspreadsheet without problem.
Our company has upgraded to office 2010 and now this step is giving me the error "cannot find installable isam".
I changed the code to reflect the new office version but that didn't help. Does anyone know what I need to change?

The database has not been converted to .accdb format.

CODE

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel4, _
     "TblInternalAudit", "\\cobwin02\FHMeterRental\FireHydrant Database\FHExport\AccountingGroup.xls", True 

RE: DoCmd.TransferSpreadsheet problem

I had a problem when upgraded to Access 2013. I tried using current version of excel and got error, so ended up using Excel9, an earlier version of excel format and that worked. Last week I had seen some code on a forum that solved the problem of being able to save to a more current version of excel format. Perhaps it will work for you. Add Xml to the ExcelType if using any format above acSpreadsheetTypeExcel9. See below:

acSpreadsheetTypeExcel12Xml 


If your goal is to save to an earlier version (you show 4 in your example), then you may need to try a number higher than 4 until you no longer receive the error.

RE: DoCmd.TransferSpreadsheet problem

(OP)
sxschech. Thanks for the example, I changed it to acspreadsheettypeexcel12 and it seems to work.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close