Access Auto-populate tables with information from text ... - 4/25/2003 11:37:08
Hey everyone,
I have yet another question. How hard would it be for me to say have the tables Residential & Commercial in my database and have them gather all of their cell values (on query) from text files named in conjunction with the table i.e Residential.txt & Commercial.txt. I assume they' ll be in the same folder (fpdb), but it really doesn' t matter where I put them I guess so long as it works. I just need an easier way around updating this database, and since I' m given the text files on a daily basis... I tend to wonder if it would just be easier to simply upload the text files and have my database gather the information for me when it is needed.
Anyone got any ideas? Please let me know :)
-Aveed-
bobby
Posts: 11399 Joined: 8/15/1969 From: Seattle WA USA Status: offline
RE: Access Auto-populate tables with information from t... - 4/25/2003 13:15:18
You could build a form that would post the data to the db.
Basically copy > paste the info in the .txt file into the form and submit...
Would something like that work?
_____________________________
In order to remove a wall you must first remove the Windows®