importing based on field names

[jsaltzman]

I have a file that contains several records constructed like this

UR| SKU

AA| Author

TI| Title

CN| Condition

AI| Illustrator

MT| Catalog

PU| Publisher

PP| Place of publication

DP| Date of publication

ED| Edition

BD| Binding

NT| Comments

KE| Keyword

PR| Price

XB| 1=Add, 2-7=Delete

However, sometimes records dont have a binding field, or edition field, or something else. It variers based on what an employee entered into the data base. The minimal a record will have is this

UR| SKU

AA| Author

TI| Title

CN| Condition

MT| Catalog

NT| Comments

KE| Keyword

PR| Price

XB| 1=Add, 2-7=Delete

So as you can see the number of fields for each record varies. So if i make a new db and have 15 fields titled like this:

UR|

AA|

TI|

CN|

AI|

MT|

PU|

PP|

DP|

ED|

BD|

NT|

KE|

PR|

XB|

can i have the records import the info into the corresponding fields that match their names?

[Lee Smith]

I started to answer you in the other thread, as your problem reamins basically the same. Please don't start new threads when you are basically still looking for the same answer.

Here is what I was going to post.

You are correct, I'm sorry it didn't dawn on me that the data was the opposit as what you needed it to be. I know that Excel has the ability to rotate the information, but I'm not savy on how this done, but prehaps others can help you here.

It seems to me the answer is a better file format to work with. What program has this .msg format?

Text is a much easier format to work with, can you get the other program to export it in text?

Lee

HTH

Lee

[cjaeger]

import all recrods into 1 field, "import"

just have a look at this attachment

http://www.fmforums.com/threads/download.php?Number=63943

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB15&Number=63943

Just mofify so it starts a new record when Left(import,3="UR"), not every 3 imported rows.