×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

DoCmd.TransferText with error 3625

DoCmd.TransferText with error 3625

DoCmd.TransferText with error 3625

(OP)
hi all
i try to accomplish with
DoCmd.TransferText acImportDelim, "Schema.ini", "TestTable", "1.txt"
that unfortunally comes with the 3625 error: "the text file specification "Schema.ini" does not exists". i've tried to put the whole path like "D:\\BlaBlaBla\\Schema.ini" but without effect :(

when i wipe out schema param, all goes fine:
DoCmd.TransferText  acImportDelim, , "TestTable", "1.txt"
but i retrieve all the 1.txt data in one column named F1 instead of separate columns.

here go my files
1.txt (tab delimited):
read    the    f    manual
search    the    f    web
do    the    right    things

and Schema.ini:
ColNameHeader=False
Format=TabDelimited
MaxScanRows=0
CharacterSet=OEM
Col1="first" Char Width 10
Col2="second" Char Width 10
Col3="third" Date Width 10
Col4="fourth" Date Width 10

both are allocated in the same directory.
any suggestions?

RE: DoCmd.TransferText with error 3625

What version of Access is this?
In 97, the help for specification has this to say:

specificationname    
A string expression that's the name of an import or export specification you've created and saved in the current database.

Nothing there about an external file.

Run through importing the text file manually using the
GetExternal Data / Import menu item.

Work through the wizard, specifying tab delimiters etc.
At the last page of the wizard, click on Advanced button.
This will show a graphic layout of your import spec.
Click SAVE
and save the spec as MYIMPORTSPEC or whatever.

Then, your VBA code should read:

DoCmd.TransferText acImportDelim, "MYIMPORTSPEC", "TestTable", "1.txt"

RE: DoCmd.TransferText with error 3625

(OP)
THANX A LOT!
I've read about saving spec in a current database but did not figure out how to do it ;) ... that's why I had chosen the way of creating my own standalone schema.

Now it works almost fine: the table creates but spacing does not fulfil. I designe tab separated flat file but the column data of Access table I'm creating does not correspond. It looks like Access does not discern tab separations but identifies some else character as delimiter instead.

While using saved schema in File->GetExternalData->Import... all works fine.

If I find the reason I'll write it below.

RE: DoCmd.TransferText with error 3625

(OP)
Well, I'm a dunce :(
DoCmd.TransferText acImportDelim, "TestImportSpec", "TestTable", "1.txt"

.... BTW, could anybody (perhaps, with native english) explain me the difference between the words

dolt
blockhead
dunce
goon
nerd

and their "lexical strength"  :)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close