Transferspreadsheet problem

[min3010]

Hi,

I am attempting to write a VBA function that transfers data from a query in access to an excel spreadsheet. The code is as follows:

'Export data to excel
Public Function dataExport()

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "dataroaming", "C:\Reece.xls", True
MsgBox "Export Complete!"
DoCmd.Close

End Function

I get an error that complains that the object "dataroaming" does not exist. However the query definately exists.

Does anybody have an idea of what the problem may be?

Thankyou!

 

[gemma-the-husky]

without checking i think dataroaming should be the name of a table in your database (can be and probably is more likely a query)

what is dataroaming in your system

 

[min3010]

Dataroaming is a query not a table. Is the code expecting Dataroaming to be a table? I was under the impression that in the syntax you can specify a query or table.

 

[qdogfball]

You have the right syntax. Maybe it doesn't like your name?

Change the query to qryDataRoaming

Who knows sometimes about the name things.