How to create text fields dynamically?

How do I dynamically load data from a delimited text file into MS Access and graph it?

• Dear MS Access/VBA professionals. I have a simple Query in my database that displays data from a handful of numeric fields and a file path from a text field. With this, I can easily create a simple report that allows me to page through the results. Okay, fine. Now, rather than display that file-path on each page, I would like to programatically load the contents of a two column, tab-delimited text file referenced by that filepath, and display that data in a graph. This way, as I page through my Query results, the report auto-loads and displays the contents of the referenced text file along side my numeric data. Basically, this database does not house the data that's contained within these referenced text files. What it maintains, for referential integrity, is the path to that file. I suspect I will be getting into some VBA for this - but was hoping somebody could point me in the right direction. Thanks!

• Answer:

  Import the text file into a table. (Right click in tables/Import.) If the files change, you'll have to do that programmatically, as you say, or just read each file into variables and display it that way (also using VBA).