revolution_records Posted July 8, 2004 Share Posted July 8, 2004 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 More sharing options...
Acheron Posted July 8, 2004 Share Posted July 8, 2004 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 More sharing options...
revolution_records Posted July 9, 2004 Author Share Posted July 9, 2004 damn, sounds like a big job :( if there's anyone who would be interested and willing to help me out with this i'd be very grateful. thanks in advance Link to comment Share on other sites More sharing options...
Acheron Posted July 10, 2004 Share Posted July 10, 2004 Here's a start Anthony: http://www.oscommerce.com/community/contri...earch,add+field The search portion ... looks like he didn't touch it, but it solves half your battle. Link to comment Share on other sites More sharing options...
revolution_records Posted July 12, 2004 Author Share Posted July 12, 2004 thanks for that... i came across it, and downloaded it, but i'm in more need of a way to convert my access table for use with my online shop.. i need all the vinyls catalogged in the products database in OS Commerce Link to comment Share on other sites More sharing options...
The_ancient Posted July 12, 2004 Share Posted July 12, 2004 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.