importing text ?

[murlen]

Hi all!

I'm trying to import a text file using comma delimited into a table

the text file is structured as such;

SOR = azjfg, OBJ = TTRE, MYR = ERDDD, ADD = T17yg, WES = 7gg
SOR = sd89, OBJ = REW, ADD = Y76dt, WES = e77, TRR = dufhf
SOR = dsfss, OBJ = DSS, QTT = ast6, MYR = ERRDS, ADD = T7yy
..etc

the first two fields are always the same 'SOR' and 'OBJ'
but the remainder are always changing

the problem is I need to import it in such a way so that it place the value for MYR in the field for MYR, the value for ADD in the field for ADD, and so on. if the record does not contain a MYR it must leave it blank.

by the way this text file as over 4000 records and there are 42 text files I have to import.

How in the world do I do this in a short amount of time?

Thanks

Murlen

 

[Vassago]

I would recommend importing all the data just the way it is in the text file, then using queries to reorganize the data. Place all the fields starting with "MYR" in one column, etc. Then you could run another query to delete any records where MYR is null.

That should work for you, if you need help understanding it, let me know.

Vassago

 

[murlen]

how can I easly Place all the fileds starting with MYR in the one column? also there are going to be over 100 fields all of which have to be in there own column.

murlen