Program to create hierarchical file?

[ruthie2012]

Does anyone know of any program that can lift data from an access database and lay it into excel or a csv file on the order required for the hierarchical import?

I have all the data I need, already in a access database, but obviously with a different structure.

Alternatively does anyone export the data directly into the actinic database tables?

Thanks

[Jarvis]

Albeit, it won't deal with very complex files, one method I have used many times with success is this.

Export your Access file to a FLAT .csv file.

Import it using 'FlatFileConvertor.exe' found in the root diectory of your Actinic application, usually C:\Program Files\Actinic v9.

You'll have to do some 'mapping' but it will work.