There are several posts on Access, but none that cover the problem I am having. I feel like my code is pretty close and I'm on the verge of success, but I've struggled for awhile now without making that last leap. Basically I'm trying to open a database in Access, and then import a tab-delimited text file and import it into an existing table. I've tried 2 different methods and neither work, but I believe they are failing for the same reason. Here's the code so far... (I'm trying this UBB Code for the first time, I hope it works)

code:

$AC1=CREATEOBJECT("ACCESS.APPLICATION")
IF @ERROR = 0
	$AC1.VISIBLE = 1
	$AC1.OPENCURRENTDATABASE("C:\DATA\KIX\BRNP\AUTHOR~1\AUTHOR~1.MDB")
	;$AC1.DOCMD.RUNMACRO("IMPORT DATA")
	$AC1.DOCMD.TRANSFERTEXT("ACIMPORTDELIM","WESDATA1","SERVICES","C:\DATA\KIX\BRNP\AUTHOR~1\SERVICES\TEST2.TXT")
	;$A=MESSAGEBOX(@SERROR,@ERROR)
	$AC1.USERCONTROL = 1
ELSE
	$A=MESSAGEBOX(@SERROR,@ERROR)
ENDIF

Everything in this works expect for the fact that it won't import the file. The macro won't run nor can I get the TRANSFERTEXT function to work. The Macro I have setup in Access works if I run it. I pulled all of the settings for TRANSFERTEXT out of the Macro's settings so I think they're right. I hope someone can shed some light on this for me. Thanks

[ 18 February 2002: Message edited by: Ben Dulaney ]