Import Specification DOES exist... sob...

[Simplycongy]

Hi,

I'm updating my backend databse by linking a user defined file. However, I keep on getting a message when I run my tabledef append that the text file specificiation ImportData doesnot exist... It does. I can see it!!!!

someoneplease help me... its friday and i want to go home....

 

[Dugantrain]

Instead of mucking around with a previously created Import Spec, why don't you just relink the .txt file, thereby creating a new spec?

 

[Simplycongy]

I am relinking the text file.. here's my code...

Set tdf = dbs.CreateTableDef("TextData")
tdf.Connect="Text;DSN='ImportData';FMT=Delimited;HDR=NO;IMEX=2;DATABASE=" & filepath
tdf.SourceTableName = filename
dbs.TableDefs.Append tdf


If there's a way to tell it to import it in the right way without faffing around with this spec, I'd love that!