Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Could Anyone Help Me Please?


Recommended Posts

Hi there,

 

I have OS Commerce installed on my server which i plan to use to run an online record shop.

 

I have a database which has been created in MS Access 2002, with a single table, holding the following fields:

 

Genre, Artist, Title, Record Number, and Comments.

 

each of the records has been catalogged into this database, with a total of over 900, and i would like to somehow import this into the os commerce product database, so that they appear in the online shop.

 

is there a way to do this, maybe through a contribution?

Or maybe i will need to convert the access database into another format and then import?

 

I don't know how to convert the database from access to, for example, csv, if that would be of any use?

 

Any help would be much appreciated.

 

Thanks.

 

Anthony V.

Link to comment
Share on other sites

There are a TON of apps out there to convert Access to SQL (as I believe phpMyAdmin only accepts Excel, CSV, etc).

 

Now if MS has included a convertor in one of the Office apps to convert Access to Excel, that saves you the trouble. With Excel, you could use phpMyAdmin or the Easy Populate contribution.

 

If you want those fields imported seperately though, and I can understand why you would, you'll need to create those custom fields in your product tables and also make some other mods around the site for the search, etc.

Link to comment
Share on other sites

here is a prgram I found using google to convert from access to mysql

 

http://www.convert-in.com/acc2sql.htm

 

then you have 2 options, one to reexport it to cvs using phpmyadmin, and the import that in to excel, format the data to conform to osCommerce Databse tables

 

or probally easier, to write a php script that will Pull the data from the converted access table(that is now in it own table on mysql) and insert it properly in to the osCommerce Product table..

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...