Excelexport query - macro is not working with SQL Linked Table

[DTO.]

Dear Friends,

I am using Linked table in MS Access from BE SQL Server. Forms and my reports are working with my queries from FE Side
But the only problem is the excel export query is not working together with Export macro. But I went to directly to look at the query itself if it is running.
And I saw those Excelexport queries which my export macro uses, is also working themselves alone

(Some additional informations - My linked table connection is done with SQL Server Driver and File DSN
I did all indexing PKs, and also relations in SQL Server side)

The same query is not working together with exportmacro. What is the solution. I will be appreciated.

Thanks

[ranman256]

you didnt provide any code from the macro.

I too have SQL backend. excel exports perfectly.
maybe try using code:

vFile = "c:\temp\ExportResults.xls"
sTabName = "results1"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qsData2Export", vFile, True, sTabName


but it should work in the macro too.

[Minty]

Cross posted here https://www.access-programmers.co.uk...orking.316114/

[DTO.]

you didnt provide any code from the macro.

I too have SQL backend. excel exports perfectly.
maybe try using code:

vFile = "c:\temp\ExportResults.xls"
sTabName = "results1"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qsData2Export", vFile, True, sTabName


but it should work in the macro too.

Hello Ranman,

Thanks but I do not have code to share. It is a macro. I choosed the conditionally export as excel file. And I choosed my query to export.
But it does not work.

[ranman256]

macro IS code
cant help w/o code.

[DTO.]

Hello Ranman256,

TransferSpreadsheet method has worked. I did not get why macro is not working when queries are based on Linked Table of SQL Server.
Maybe export macro of Access is not competible with SQL Server.