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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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.
 
Back
Top