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.
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.
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 ?
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
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
