Hi PHV
I have created a variable with the the query in it and used that query to export but still it is giving an error saying object or path not found.
what path we need to give for this ?
Thanks a lot PHV I have tried this statement but it is giving me an error for the table name says microsoft JET could not find this object name
Where do we need to create this table ...in access or VBA
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "table1", "C:\Documents and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.