Populate from text file

[jped]

I have a text file that has a large list of entries that is updated every
week. It has a job number with a corresponding job name. It is just a .txt
file. Is there a way to link my database to this file? I would like to have
a drop down box with the job number and name in it. Can I create a table
that links to this text file and is updated when the text file is updated?
Please Help!

Thanks!

 

[Brian]

TransferText action - look up the syntax for TransferText in the VBA help.
You can either import or link the data. The text file will need to be
delimited or fixed-width.

If you need more specifics, post some specifics concerning the layout of the
text file:

What is the file path & name?
Is it delimited (tab or commas between columns) or fixed width?

 

[John Nurick]

If it's an ordinary text data file (delimited or fixed width) just use
File|Get External Data|Link

 

[jped]

That worked, Thanks!

If it's an ordinary text data file (delimited or fixed width) just use
File|Get External Data|Link