TransferText

[Claes D]

Hello.

I have a little problem.
When I import a ;-separated file "manually" with the wizard (using a saved
import specification), the data imported are placed in the correct fields in
the table and all the data is ok.
When I import the same file, using the same import specification but in VBA,
something goes wrong.
The data is placed in the correct fields, but the data is also followed by a ;

Example
I import manually, I get the data 123
When using code, I get the data 123;

Since it works manually with the import specification, that one seems ok.
In the code there is nothing stating anything except the usual, like
acImportFixed and also the spec name and table name.
No info about delimiters or anything.
But the import in itself works fine, its just the ; delim that is there even
though I dont want it.

Anyone know why this is happening?

Thanks

 

[Claes D]

Obviously I'm very tired, lol.
When I read my own post, I saw what was wrong.
Clumpsy me.

acImportDelim