database query

[seanpaul]

Hi All,

This is abit of an odd one, what I want to do is export all my products from actinic v6 to an access database, we have a database set up which used to be used for data entry then linked to actinic we would then just drag n drop the newly inputted products into the correct section. Basicaly I want to reverse this process!

Any ideas would be greatly appreciated.

[Jan]

You can export your catalog to a CSV file and then import that into your catalog OR you can access the tables directly, I think that all of the fields that are linkable through external linking are in the products table, so it would be matter of importing that table from catalog, if you only want certain fields you can select those during the import. You can import either from the ODBC connection which is called ActinicCatalog6 OR by access the catalog.mdb file directly.

Regards,

[NormanRouxel]

Don't forget that Actinic 6 uses an Access database. It needs at least Access 2000. So you can simply open ActinicCatalog.mdb and use a query to write a new database containing just the fields you require. I think the table you need to look at is Products.

Norman

[cdicken]

What I tend to do is go to 'File | Export' and then export a hierarchical file containing all your catalog data. Then open this file in Excel and sort it by the first column.

If you then scroll down, you will see that this sorting has put all the products together in one block, which can be easily copied and pasted into an Access db.

[seanpaul]

thats great guys, all the info I needed.

thanks