chrometweaks.org

What is the best, affordable, and most user-friendly web iPage hosting service?

Click Here To View All Answers...


Got a quick question: What is the best, affordable, and most user-friendly web iPage hosting service? Thanks in advance for any answer or 2. My other question... 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..

This post has been edited by.

Revolution_records.

: 08 July 2004, 17:21..

Comments (117)

That's a good question. I'm not sure what is the answer to that question. I'll do some investigation and get back to you if I find an useful answer. You should email the people at iPage as they probably could help you..

Comment #1

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..

Comment #2

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...

Comment #3

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..

Comment #4

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....

Comment #5

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..

This post has been edited by.

Revolution_records.

: 08 July 2004, 17:21..

Comment #6

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 iPage site for the search, etc...

Comment #7


This question was taken from a support group/message board and re-posted here so others can learn from it.