Importing from msAccess

[damnedpig]

I've not tried yet this, but:
Does some1 know a way to import the articles contained in a msAccess db to the oscommerce (or osC MS2-MAX) DB ?
Thanks in advance. Hope your help.

[jpf]

Yes - Comma Separated Values or CSV format. Access can IMPORT/EXPORT in this format.

Then using the EasyPopulate(EP) contrib (included in MAX) to export data and reimport it.

Note: EP normally only works with the item numbers. If your looking to import "other" things then use your MySQL admin tool (like phpMyAdmin) to export any table in CSV format then edit/modify in Access then re-export - then import back into your OSC database. Always do this on a backup TEST site first!
Consult the PDF (that is included with MS2 and MS2-MAX archive files) for the database table and what is linked with what - just incase there are other entries that have to be made in other tables....

Good luck