Importing text into multiple tables

[jaf893]

I have a database with the following one to many mappings:

Prototype => Device => Test Conditions => Test Results

When I input data manually the database works fine and each set of results is associated with a set of test conditions which is in turn asssociated with a device etc. However, all of the information I have is stored in .txt files and so when I import it using the Get External Data function it isn't linked together. How can I import the data so that it is linked together?

I'm sorry if this isn't very clear - I am more than happy to clarify anything.

Thanks in advance,

JAF
jaf893@gmail.com

 

[Ron_dK]

Jaf,

Make a query which contains all fields that you want import to :

e.g. prototype field1, device field2, test condition field3, etc.
Than import the txt data in this query et voila.

 

[jaf893]

I have created a query but I can't work out how to import text into it.

JAF
jaf893@gmail.com

 

[Ron_dK]

Sorry my mistake.
You should make a table, not a query.

 

[jaf893]

That didn't work because they are stored in seperate text files. The massive table looks a bit like this now

# # # # # # # # #
* * * * 
* * * *
* * * *
* * * *
* * * *
* * * *
        * * * * *

The # are the field titles. The * is the data. the left hand * are from the results and the right hand * are from the observations

 

[Ron_dK]

Jaf,

You'll need to run a query to add the appropriate records to your existing tables. In this query you can define what (field) data needs to be appended to what table.

 

[jaf893]

I have "solved" the problem

I use GNU AWK to merge all of the text files together. I then imported them as one big text file and used the table analyser to separate the data into seperate tables.

Thanks again for all your help.