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,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?A string expression that's the name of an import or export specification you've created and saved in the current database.
Hope that's clear!Code:DoCmd.TransferText _ transfertype:=acExportDelim, _ specificationname:=sQuery & " Export Specification", _ tablename:=sQuery, _ Filename:=CurrentProject.Path & "\Exports\" & sQuery & ".csv", _ hasfieldnames:=True DoCmd.Close
TIA