The script does append the data into the table. I'm not sure how to make it replace (not my goal here anyway). Here's what I ended up with...

code:

$DATABASE="C:\DATA\KIX\BRNP\AUTHOR~1\AUTHOR~1.MDB"
$TABLE="SERVICES"
$TEXTFILE="C:\DATA\KIX\BRNP\AUTHOR~1\SERVICES\TEST2.TXT"
$SPEC="WESDATA1"
$AC1=CREATEOBJECT("ACCESS.APPLICATION")
IF @ERROR = 0
	$AC1.VISIBLE = 1
	$AC1.OPENCURRENTDATABASE($DATABASE)
	$AC1.DOCMD.TRANSFERTEXT(,$SPEC,$TABLE,$TEXTFILE,0)
	$AC1.QUIT
	$AC1=0
ELSE
	$A=MESSAGEBOX(@SERROR,@ERROR)
ENDIF

Thanks again for your help Shawn.