PDA

View Full Version : Importing a XLS spreadsheet - which program to use?


TWood
07-05-2009, 10:38 PM
Hello,

I'm on a Linux hosting plan with MySQL and phpMyAdmin, and I have limited experience with both. I want to import an XLS spreadsheet into a second database and eventually get the vB database and this new one sharing information. I need OpenX to be able to use both databases (plus its own) in order to select the correct ad for a given location.

Is phpMyAdmin adequate for this type of work? I also have the OpenOffice database program, called Base.

I also see there's a program called Navicat that is an additional cost. Will this program give me better management tools than phpMyAdmin and Base?

Thanks,

TW