Creating a new table/records from a single field

[Guest]

I have data that I import into Access 2007, the table is simplified but looks
like the example below.
Record 1
Field1 =date 08/08/07
Field2=Price $44.00
Field3 =serial # (this field varies in size, but always 12 digits followed
by a comma until last serial then no comma up to 9 groupings of 12 digits)
example 000000000001, 000000000067, 000000004359

I would like to create a new table listing only the serial numbers from the
first table.
So the record above would create 3 new records in my new table.
Record 1
000000000001
Record 2
000000000067
Record 3
000000004359
I need no other data from the first table other than serial numbers. I
appreciate any ideas anyone may have. Also i do not want to create a new
table every time, populate a table would be a better way to explain it
(Create it once.)

 

[Guest]

You are better off dealing with it in Excel before importing. So much easier.

 

[Guest]

How can i have Excel seperate a field into seperate lines. keep in mind we
are talking about 3000 records every week.

 

[Pete D.]

See,
http://www.mvps.org/access/strings/str0003.htm

Pete D.