How do I convert a linked text file table, into an access table

[Guest]

I made a mistake; When importing my data from the text file, I guess I chose
a linked table. Good grief, what a worthless tool. How can I convert it
back into an access database without reassigning all of my fields, and there
are over 70, it took 2 hours to set it up the first time. There are errors in
the linked text file, and I cannot correct them and then have access
recognize it.

 

[Nikos Yannacopoulos]

Forest,

While you have your linked tet file, make a Make-Table query on it, so
Access will create the table for you.

HTH,
Nikos

 

[John Nurick]

Basically all you have to do is

1) create an ordinary Select query that gets all the fields from your
linked table.

2) convert this to a Make Table query (there's a command on the Query
menu).

3) run the Make Table query.