Getting a CSV file out of actinic

[jxm28788]

I need a flatfile CSV file with a complete list of all my products, with the product part number (customvar) field and price field. How do I get it out of actinic?

Export is no good as it's heirarchical (and so big it doesn't actually fit in excel!)

Is there a simple query I can do from access? If so how? (I also need it sorted by part number)

Or a report from inside actinic...?

[fergusw]

To get this export from Access WITH the CUSTOMVAR would require a slightly less simple query that you hope for, I suspect.

In V7 CUSTOMVAR's are maintained in the ProductProperties table, as are Choices, attributes, permutations, components and price schedules, so things can get a little confusing.

The basic SQL query would be something like:

SELECT *
FROM Product LEFT JOIN ProductProperties ON Product.[Product Reference] = ProductProperties.sProductRef WHERE ProductProperties.nType = 3;

Note: Untested!! Would probably cause a problem if there were multiple CUSTOMVARS for each product.