Exporting merged database

[allanl]

I hae a base linked database via an Excel spreadsheet, and I have updated the Actinic database using the import update facility increasing the size of the number of items.

The resulting database has a mix of linked items and regular items.

How can I export the whole lot into a simple Excel sheet, so the entire database can be price adjusted within Excel?

I do NOT want a hierarchical spreadsheet as its useless in my opinion.

[Jan]

You could always link the Actinic product table into excel and then update prices in that spreadsheet. Be careful though because if you have any price schedules or permutations will prices they will be stored in a different table (product properties).

Regards,

[Jan]

Actually your linked products are not stored in the product table so you would need to either link to both tables and make the changes twice or make a query to link the tables together (actinic has a linked table pointing to your external table) and then link to that in excel - making the query might make it read only though - you can make the query in either excel or access.

Regards,