EXPORT into Formatted Excel Spreadsheet

[paulbeckett]

Hi

I would like to try and export my product details into a Excel spreadsheet and be able to arrange them by product (per row) and then all or selected properties (including custom properties) (per column).

For example

Prod Ref, Prod Name, Short Description, Price, Stock Avail, Custom Prop - Supplier Ref.


Is this possible?

Many thanks

Paul

[Mike Hughes]

The way I would do this is in excel.

Data > Get External Data >New Database Query

Then browse to the actinic database and select the product details you want in your spreadsheet. You can then define a sort and filter before the details are imported.

Mike