Populate from text file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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?
 
If it's an ordinary text data file (delimited or fixed width) just use
File|Get External Data|Link
 
Back
Top