3625 error

[workingboy456]

I have an access application that imports a bunch of text and xls files.
Recently someone told me that there is a new text file that needs to be added
to the application. So I went into the VB module and saw a bunch of lines
that looked like this:

DoCmd.TransferText acImportDelim, "FilenameA Import Specification",
"FilenameA", CurDir$ & "\FilenameA.txt", False, ""

What I then proceeded to do was to add a line to this code that basically
stated the above in the following fashion for the new file, called FilenameB.
txt:

DoCmd.TransferText acImportDelim, "FilenameB Import Specification",
"FilenameB", CurDir$ & "\FilenameB.txt", False, ""

However when I run the application to start the import I get an error:
3625-THe textfile specification 'FilenameB Import Specification' does not
exist . You cannot import, export, or link using the specification.

What went wrong?

 

[dymondjack]

When text files are imported using the wizard, an Import Spec is also created
for them, that defines how the data is structured within the text file.

I've never had to do this, but have seen some other similar posts where
people were advised to use the import wizard, where you can apparently save
the spec, and then use the saved spec for FilenameB

I'm assuming the spec can be created without the wizard, but don't know how.

hth

--
Jack Leach
www.tristatemachine.com

- "Success is the ability to go from one failure to another with no loss of
enthusiasm." - Sir Winston Churchill