I used the following comma-delim text file:

First,Last,Member
Shawn,Tassie,173
Ben,Dulaney,3314
kdyer,,1559

with field names on first row, and the following snippet of code (based on your code):

BREAK ON

$DATABASE = "M:\ACCESS\DB1.MDB"
$TABLE = "NEWTABLE"
$TEXTFILE = "M:\ACCESS\TEST2.TXT"

$AC1=CREATEOBJECT("ACCESS.APPLICATION")

$AC1.VISIBLE = 1

$AC1.OPENCURRENTDATABASE($DATABASE)

$AC1.DOCMD.TRANSFERTEXT(,,$TABLE,$TEXTFILE,-1)

?"@SERROR"

$AC1.USERCONTROL = 1

$AC1.QUIT

$AC1 = 0

EXIT 1

Hope this helps

-Shawn