PDA

Click to See Complete Forum and Search --> : Can Access create a table according to information taken outside of the DB?


phoenix
Jul 7th, 1999, 05:01 PM
I am attempting to creat a table in Access which is based on information from three notepad.exe documents. One document contains the actual information, another contains the position of the data and the field names, and the last contains information on the type of data in each field. Is there any way I can have Access open up each file in sequence and have it organize the data according to where the other two documents say it should go?

bashfirst
Jul 9th, 1999, 06:26 PM
You could open the files and read them like text files, interpreting the instructions a line at a time and then use the CreateTable, CreateField, CreateIndex methods according to the instructions.... Or, you could link to the text files directly, if they are formatted consistently, and read the instructions in like records from a table.

Hope this helps.
Bash