var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: TransferText not working
I'm trying to export a query to a textfile by running script with WSH, but all I'm getting is an error (MSAccess: Query must have at least one destination field.)
This is the code I'm using:
Set objAccess = CreateObject("Access.Application.9")
.DoCmd.TransferText acExportDelim, , strQuery, strExportFile
Set objAccess = Nothing
strQuery is the name of the query in Access, strExport is the full path and name of the .txt file I want to export to.
whenever I se that message it means I am running an append query and have desigantes the destination tables fields
the query is a SELECT, but if I try the same code with a normal table and try to export that, it doesn't work either.
The file I'm trying to write to exists, is writable and empty. I still don't understand the error message...