Text To Access Database

Hi Guys/Gals,

I want to transfer data from a dat(eg: abc.dat) file to access table format. And i want that the fields created in the table should be dynamic. it means that if i have six words in my dat file all the six words should go into six different fields.

And if i write some more things that should be overwritten in the dat file but that words should be appended to the access table. and suppose if the new record has nine words then these words should go in nine different fields

any help would be highly appreciated and if anybody has got any sample example.pls mail me

thanking you
vishal.

Have you tried thetext import wizard, its a bit crap, but it might do what you want, otherwise you are looking at direct file handling using things like INPUT #1 etc.

Cheers,
P.

Thanks Paul I will try that option but if u have got any more ideas pls reply. Thanking again for ur prompt reply and help


--vishal