Results 1 to 2 of 2

Thread: Can Access create a table according to information taken outside of the DB?

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 1999
    Posts
    1

    Post

    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?

  2. #2
    Lively Member
    Join Date
    Jun 1999
    Location
    Raleigh, NC
    Posts
    70

    Post

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width