convert a linklist to relational database

I have a database has the following linklist structure. A, B, B1, B2 and B3 are records.
A is a group and the others are group members
***************************************
A.PointertoB
B.ForwardPointertoB1
B1.ForwardPointertoB2
B2.ForwardPointertoB3
B3.end
***************************************
I want to convert them to relational database structure so I need to find following pointers

B.PointertoA
B1.PointertoA
B2.PointertoA

Can I use sql to find the pointers? Thanks in advance.

Hi,

In your exisiting system do you have the ability to extract data out as char or text etc. if yes you can extract the data out,

Import all of it into a SQL table and then a write a T-SQL routine that will manipulate or extract data out of it. Once your happy that it works you can embedd the routine within DTS or SSIS.

I would do this. Some one might have a different idea.

There might also be third party tools that you can use.

Jag