I
am also trying to achieve the same, I will be using XML to retrieve records then write to a tEMP file, then import into SQL.
Hope fully automatically.
I also have a problem, how do I calculate the TOP LEVEL categories belonging to a lower category (they go 7 deep)
Has anybody got any clues on this one
example
Cat:Amplifiers
CatID:4000
ParentID:3200
LevelID:3
How do I get back to parent cat without doing 3 SQL calls.
3100 - HIFI
3200 - Car Stereo
4200 - Amplifiers