Database Questions

[deemurphy]

Can we import from an excel spreadsheet into the database? Can we use the MySQL ODBC Connector to do the import?

Thank you
LadyDee

[kobra]

Can we import from an excel spreadsheet into the database?
Can we use the MySQL ODBC Connector to do the import?

Yes to both BUT you ned to know what you are doing as one can insert things that are not inline with the specified/required structure

Always backup - - don't attempt this on a live store a first go
Practice on a test shop

[deemurphy]

Thank you, I will test this on my server first.

LadyDee

[afo]

This might help http://www.zen-cart.com/index.php?ma...roducts_id=395

[deemurphy]

Thank you. You have been so very helpful. I will test both of them on my home server, not my live one. I really appreciate your assistance because I have a large quantity of products. (lighting and bulbs),

LadyDee

[deemurphy]

So this is something you have to purchase?

Thank yiou
LadyDee