alternative to transfertext?

[kerrigirrl]

i'd like to automate linking a table into my db, but transfertext action won't allow me to change it. it also gives me errors such as permission denied or open by another user, (which i know it's not!).

is there an alternative to using transfertext to link to a text file? if i manually link through file, get external data... everything works fine, but the intended users for this application would need something simpler than that.

thanks in advance,
kerri

 

[petermeachem]

kerri,

Is it a huge long file ( I see from another post it is a bit wide ). You could use code to open the file, read it, split your funny fields up and save it. Its really not hard. Peter Meachem
peter@accuflight.com

 

[kerrigirrl]

i've taken care of that file, this is completely different. when i link with the transfertext method, it gives me errors when i go to run queries on it. i'm using it to create another table, not changing anything in the linked table itself. i was told there was another way to automate linking a text file into access, but nobody said what method to use. access help and microsoft only mention the transfertext.