Link to home
Start Free TrialLog in
Avatar of SSF
SSF

asked on

TransferText in Access

I'm trying to import a delimited text file into a table in Access. I'm running the code
.
.
.
Text1.LinkTimeout = 10
Text1.LinkTopic = "MSACCESS|" & strPath
Text1.LinkItem = "All"
Text1.LinkMode = 2

cmdstr = "[TransferText 'Import Delimited', 'RGCNSEQ2 Import Specification', 'RGCNSEQ2','u:\access\usa\usa_down\rgcnseq2.txt']"
.
.
.

I get a message "foreign application will not perform dde method or operation". what's wrong?
ASKER CERTIFIED SOLUTION
Avatar of AnswerTheMan
AnswerTheMan

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SSF
SSF

ASKER

thanks!