linking tables

J

JLatham

Short answer - no. The only 'linking' is via the Linked Table Manager which
is for linking to tables in other database files.

Access does have a text file import Wizard which works much like the one in
Excel, if you are familiar with that one, which will allow you to import a
fixed field length or (comma) separated value file into a table.
 
R

Rick Brandt

The linked table manager (as well as linking in code) can very easily create
links to text files...and Excel files, and Paradox, FoxPro, in fact any file
type for which there is an appropriate ISAM or ODBC driver.
 
H

Hemant_india

hi
importing txt file in a table is ok
but ,actually txt file i receive changes frequently
i mean sometime it gives 100 records and next time it may come with 1000
also a particular record may not be included next time and also the
possibility of new records.
in such case refreshing will not also help
any ideas ?
 
J

John Vinson

hi
importing txt file in a table is ok
but ,actually txt file i receive changes frequently
i mean sometime it gives 100 records and next time it may come with 1000
also a particular record may not be included next time and also the
possibility of new records.
in such case refreshing will not also help
Click to expand...

jlatham was mistaken. It is in fact possible to link to a text file;
use File... Get External Data... Link and choose .txt as "files of
type". The linked "table" will not be updateable but it can be used in
queries and searched, sorted, and linked to other tables.

John W. Vinson[MVP]
 
Top