Creating Multiple Records From The Data In One? 1

[BTilson]

Let's say I have a record in one table of this:

1 2 3

I need to figure out how to take this record, and in another table create individual records of:

1
2
3

Another example:

One record of:

3 18 23 45

Create in a new table these records:

3
18
23
45

I can see how this can be done in my head, but I can't for the life of me make it happen with code.

Does anyone have any suggestions?

Brooks Tilson
Database Development
Tilson Machine, Inc.

 

[Remou]

You can use split, if you have a suitable delimiter:

astrOut=Split(rsIn!Field1," ")

For i=0 To Ubound(astrOut)
   rsOut.AddNew
   rsOut!Field1=astrOut(i)
   rsOut.Update
Next

rsIn.MoveNext

 

[BTilson]

Hey, that did it perfectly. Thank you very much!

Brooks Tilson
Database Development
Tilson Machine, Inc.