[ic] Importing tables -- categories [Linking MS Access to MySQL]

[interchange-users@interchange.redhat.com]

Dear Dave,

I would suggest using Microsoft Access.  You can link them if you are using a real database such as MySQL, etc..you'll need an ODBC driver and a decent understanding of creating Access databases.  Any changes you make to the access database are changed in the server database in real time.  THIS IS COOL!

It may take a bit of set up time but you'll accomplish these very important things.
- Easy to Use
- Changes Instantly
- Easy for customer to use
- Quickly add products/categories/whatever
- or modify them...

You can create a link database and create forms for your products, and subforms under your products form for your inventory, options, etc...for that product.

There is also a great utility called MyAccess which is an Access plugin that will open MySQL databases. Do a search on the net.

Regards,

Chris Chaney

On Jun 04 23:00, "Dave Turk" <interchange@montanaservers.com> wrote:
>
> Subject: [ic] Importing tables -- categories
>
> Hi All,
> I have a couple of carts up and going finally, with the help of all of you!
> I need to import more products as well as categories.
> I am using XLS format and when I import using the table import utility in
> the admin section I find that I need to import the area and cat tables
> seperately and reorder the sort numbers, what a pain!! Is there a way to use
> the table import feature that is used in the wizard without loosing all
> the changes made to various pages of the site, or is there simply a better
> way to do things? How about if the customer wanted to add products
> themselves? They would never be able to do it.
> I don't have much hair left.
> Thanks for any help or suggestions.
> Dave Turk
> 
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
> 
>