I am new to database programming, so bare with me. I have created an access database of which there are many tables. Each table will hold records of data captured on a specific date. You see I have these text files created on a daily basis and I want to suck them into a database. I shouldn't have much trouble perging the text files for the data I want to insert, but I do not know how to put certain data in certain fields. Each table is setup as:

date(txt file was made) | datapoint1 | datapoint2 | datapoint3 | etc...

One more thing, each text file has information for each one of my 32 tables, so I will have some hoping around to do. At this point, this functionality does not require any graphical intervention, just populating a database.

Any ideas on where to start? I have already made my connection using VS, not in code.

Thank you all.