text file as linked table

S

SAC

Is there any problem with linking a text file as a table or should I improt
it into a table and then manipulate it?

Thanks.
 
J

John Vinson

Is there any problem with linking a text file as a table or should I improt
it into a table and then manipulate it?

Thanks.
Click to expand...

Depends on what you want to do with it. Linked Text files will not be
updateable, and will not have indexes, so queries may be slower than
with an imported (and indexed) table. Some queries including a linked
text file may not be updateable while they would be with a local
table.

John W. Vinson[MVP]
 
C

CyberTaz

Hi SAC-

IMHO there are any number of potential problems associated with linking to
text files... so much so that I can't even say for sure that it can be done
because I've never tried it. Probably can, but I wouldn't want to except
under very special circumstances.

Importing the data as a new table (or appending the records to an existing
table) is a much more secure approach. Even if the data is only needed on a
temporary basis it can be deleted easily enough.

HTH |:>)
 
S

SAC

Thanks!

CyberTaz said:
Hi SAC-

IMHO there are any number of potential problems associated with linking to
text files... so much so that I can't even say for sure that it can be done
because I've never tried it. Probably can, but I wouldn't want to except
under very special circumstances.

Importing the data as a new table (or appending the records to an existing
table) is a much more secure approach. Even if the data is only needed on a
temporary basis it can be deleted easily enough.

HTH |:>)
Click to expand...
 
S

SAC

Thanks John.

John Vinson said:
Depends on what you want to do with it. Linked Text files will not be
updateable, and will not have indexes, so queries may be slower than
with an imported (and indexed) table. Some queries including a linked
text file may not be updateable while they would be with a local
table.

John W. Vinson[MVP]
Click to expand...
 
Top