Before I buy: Access to MySQL

I have a customer who I set up with a shopping cart YEARS ago. Her current cart uses ASP and an Access database. She has almost 3,000 items in her inventory.

She's having trouble with this outdated cart now, so I'm looking at options for her. One is to stay with the cart she uses, but upgrade. Another option is to switch PowerStore.

Her main concern is whether her inventory will all have to be re-entered into whichever new cart she goes with. (I haven't gotten an answer back yet with her current cart company.)

Now here is where I show my ignorance: can her inventory data somehow be imported (exported?) from Access to work in MySQL? I realize there are tables and "stuff" that will have to somehow match up, but will she have to re-enter everything one by one?

Thanks for your help!

~Fergie

Haven't used this but you might try:
3.0/

or you could try csv files.

In order to transfer items properly you should determine if the fields match what is needed by the PowerStore. This will help you figure out how much can be transfered and what must be changed, removed, or edited.

You can take a look at the PowerStore demo and look at one of the products update page to get a feel for what values are used in PowerStore and how it compares with the existing store. Here is a link to the PowerStore page, the demo is on the right side:

powerstore/