DoCmd.TransferText acExportDelim Troubles

[svcghost]

Hey guys,

I'm having trouble exporting an additional column of data to a text file.

Here is my code:

DoCmd.RunSQL ("SELECT SubscriberKey, AccountNumber, EmailAddress, FullName, SubscriberType, FractionSuiteGroup INTO ExportSubscriberTemp FROM " & vEventID & "_C;")
DoCmd.TransferText acExportDelim, "ExportSubscriberData", "ExportSubscriberTemp", "C:\Campaigns\" & vEventID & "\subscriber_data.txt", 1

When I add a column to the SELECT statement, I first get a "SELECT INTO" error that says that the column I added was an unknown column. Even though that column exists in both the SELECTED table and the INTO table. Then when I try to continue with the VBA code, it says recordset not updateable.


Any ideas? THANKS guys!

[svcghost]

Nevermind guys I got it. Fixing this involved an overly complicated task. I had to open the table, export it as a text file, then go into advanced options, click specs, and then find the specification name above, then add a field to it.