Exporting a query results

[Tony Williams]

I'm trying to export the results of a query to a tab delimited file. Here is
the command button code:

Private Sub cmdexport_Click()
DoCmd.TransferText acExportDelim, "Test Export Specification", "qryexport",
"C:/Test/Test.txt"
MsgBox ("Test Export File Created")
End Sub

However I'm getting an error message that says
"The data being exported does not match the format described in the
Schema.ini file."
I've no idea what this is, can anyone help as the Help behind the message
doesn't help at all?
Thanks
Tony

 

[Tony Williams]

Sorry guys have solved my problem. The export specification was looking at a
table rather than the query and so there were too many fields in the
specification. You live and learn!
Tony