Export from ACCESS: DoCmd.TransferSpreadsheet acExport - size of the exported table name restriction

[esoestemp]

Hello MS Access experts,
I try to optimize a DB using exporting with DoCmd.TransferSpreadsheet function.
I have the following issue - it seems there is a restriction about the number of the symbols in the name.
For example when qry_Name_to_export consists more than 24 symbols I get an error:

[" is not an valid name. Make sure it does not include invalid characters or punctuation and that it is not too long]

Below is the code of the function.
Is there a way this size restriction to be avoided/expanded?

Thanks in advance for your help!

=====================================

Option Compare Database

'------------------------------------------------------------
Function Macro4()
On Error GoTo Macro4_Err

DoCmd.TransferSpreadsheet acExport, 10, "qry_Name_to_export", "C:\Temp\qry_Name_to_export", True, ""

Macro4_Exit:
Exit Function

Macro4_Err:
MsgBox Error$
Resume Macro4_Exit

End Function

====================

Best rregards

 

[ranman256]

correct...you can only use legal file names. There's no need to use crazy characters.

 

[esoestemp]

I am not sure your comment is relevant.
I dont use crazy characters and if you did not read my first post - the size is the problem.

 

[alansidman]

I believe that you are missing a file extension in the file name. Perhaps an .xlsx or .xls, etc.