[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] Importing tables -- categories [Linking MS Access to MySQL]
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
>
>