kenabbott
asked on
Ms Access docmd.transferspreadsheet
Hi
I am trying to use transfer spreadsheet to transfer data from a table into a spreadsheet (I am using A2010 and Excel 2010). The file transfers successfully but when I try to open it I get a message saying the extension doesn't match the file. I am assuming the problem is with the Transfer Type that I am using - what is the correct syntax to transfer to an Excel 2010 spreadsheet?
Many thanks
I am trying to use transfer spreadsheet to transfer data from a table into a spreadsheet (I am using A2010 and Excel 2010). The file transfers successfully but when I try to open it I get a message saying the extension doesn't match the file. I am assuming the problem is with the Transfer Type that I am using - what is the correct syntax to transfer to an Excel 2010 spreadsheet?
Many thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER