Semicolon (;) import specification behaving as fixed length

[Anika]

I am very unfamiliar with VB and am dabbling in Access more as self-study and a hobby. I am attempting to import a semicolon delimited text file into an existing table using a comand button and saved import specifications. The file imports, but it acts as though my specs were fixed length not semicolon delimited, therefore, I get a bunch of gibberish.

I am working with (very outdated) Access 2000. Could someone please shed some light or point me in the right direction?

Many thanks.

- Code Kiddie

 

[Anika]

All fixed! I decided to use the transfertext method instead.

-Code Kiddie

 

[gemma-the-husky]

perhaps the saved import spec was using the wrong separator - using a spec is one option in the docmd.transfertext, so it should have worked

and access 2000 isnt a problem at all.

except i think the default recordset type is ADO, rather than DAO