VBA: TransferText Method Export Specification string limitation?

[Nobody]

I'm trying to confirm my suspicion that the export specification is only allowed to be ¿54? characters long when used in the transfertext method in exporting a query to a file from access.

In my case, I made a module to run down the list of queries I need to run periodically (50+ queries) and made export specifications for each, using the default name '<query> Export Specification' for use in the transfertext method... and it errors on the queries with long titles (query name >43 characters)

Checking with microsoft I didn't see this to be the case,

A string expression that's the name of an import or export specification you've created and saved in the current database.

and I just need to know if I HAVE to shorten the query name, or use a different naming convention for the export specifications. Or maybe I'm off-base?

    DoCmd.TransferText _
        transfertype:=acExportDelim, _
        specificationname:=sQuery & " Export Specification", _
        tablename:=sQuery, _
        Filename:=CurrentProject.Path & "\Exports\" & sQuery & ".csv", _
        hasfieldnames:=True
    DoCmd.Close

Hope that's clear!

TIA

[Nobody]

I edited the code to the following and it works...

    DoCmd.TransferText _
        transfertype:=acExportDelim, _
        specificationname:=Left(sQuery, 43) & " Export Specification", _
        tablename:=sQuery, _
        Filename:=CurrentProject.Path & "\Exports\" & sQuery & ".csv", _
        hasfieldnames:=True
    DoCmd.Close

And based on my test of a long query title, Access2007 does, in fact, cut off anything after 43 characters for the default export specification title.

<The more you know>