Exporting a query results

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

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
 
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
 
Back
Top