text file as linked table

[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.

 

[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.

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]

 

[Guest]

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 |:>)

 

[SAC]

Thanks!

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 |:>)

 

[SAC]

Thanks John.

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]