import customers access database

[millhouse]

HI, advice needed

 

I have approx 5000 customers and all their details stored within an ms access database. How can I import this information into mysql database? Is it possible?

 

many thanks

 

Ed

[ErollorD]

it's possible but this is a hard one. You need to have same user details as in oscommerce then you export and import into osc...

[millhouse]

it's possible but this is a hard one. You need to have same user details as in oscommerce then you export and import into osc...

 

OK I'm not sure I'm with you.

 

You mean that the data fields have to be the same? I then export from osc into the access database before importing it all back in?

 

Can you explain in a little more detail?

 

thanks

[ErollorD]

as I understand you, you want to import users from your database to osc, right?? but if you want everything to work as it should, you need to input this data

 

address_book_id int NOT NULL auto_increment,
  customers_id int NOT NULL,
  entry_gender char(1) NOT NULL,
  entry_company varchar(32),
  entry_firstname varchar(32) NOT NULL,
  entry_lastname varchar(32) NOT NULL,
  entry_street_address varchar(64) NOT NULL,
  entry_suburb varchar(32),
  entry_postcode varchar(10) NOT NULL,
  entry_city varchar(32) NOT NULL,
  entry_state varchar(32),
  entry_country_id int DEFAULT '0' NOT NULL,
  entry_zone_id int DEFAULT '0' NOT NULL,

 

now can you do this??

[mzm22]

I actually need to do something similar. I'm importing all the data from a hand coded shopping cart into OSC. I migrated the product data from an access DB to a My SQL using the MYSQL migration toolkit. Then I just modified the tables to be compatible with OSC using PHP my admin. I know that is probably not the most elegant solution, but it worked ( and I'm not good enough with MYsql to be elegant) :blink: . However i ran into a wall with the customer data due to the fact that the old DB stored the passwords in plaintext and OSC runs them through an MD5 hash. Anyone have any thoughts? Sorry for adding more questions rather than answers, and thanks in advance.