Announcement

Collapse
No announcement yet.

Exporting merged database

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Exporting merged database

    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.

    #2
    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 Strassen, Mole End Software - Plugins and Reports for Actinic V4 to V11, Sellerdeck V11 to V2018, Sellerdeck Cloud
    Visit our facebook page for the latest news and special offers from Mole End

    Top Quality Integrated label paper for Actinic and Sellerdeck
    A4 Paper with one or two peel off labels, free reports available for our customers
    Product Mash for Sellerdeck
    Link to Google Shopping and other channels, increase sales traffic, prices from £29.95
    Multichannel order processing
    Process Actinic, Sellerdeck, Amazon, Ebay, Playtrade orders with a single program, low cost lite version now available from £19.95

    Comment


      #3
      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,
      Jan Strassen, Mole End Software - Plugins and Reports for Actinic V4 to V11, Sellerdeck V11 to V2018, Sellerdeck Cloud
      Visit our facebook page for the latest news and special offers from Mole End

      Top Quality Integrated label paper for Actinic and Sellerdeck
      A4 Paper with one or two peel off labels, free reports available for our customers
      Product Mash for Sellerdeck
      Link to Google Shopping and other channels, increase sales traffic, prices from £29.95
      Multichannel order processing
      Process Actinic, Sellerdeck, Amazon, Ebay, Playtrade orders with a single program, low cost lite version now available from £19.95

      Comment

      Working...
      X