Import access query result to Excel gives an error 1

[Katya85S]

I’m trying to import access query result to excel file and get “The type isn’t an installed data type or doesn’t support the operation you choose” error. In the code for data type parameters I’ve tried both living it blank and using “Microsoft Excel(*.xls)”. My code is:
strDirectory = "\\ServerName\ShareName\FolderName\OutputFile.xls"
DoCmd.TransferDatabase acImport, , , acQuery, "qryQueryName", strDirectory, 0
What do i do wrong?
Thank you all in advance.

 

[PHV]

Have a look to the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Katya85S]

Thank you very much PH! This helps