Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, I'm trying to figure out the best way to use Excel to upload data to a
MySQL database. I want to use Excel (rather than Access) because of its general purpose edit and calc capability. I've seen reams of articles on how to import FROM a database. But, I want to push TO a database. Is this possible? If so, what is the best way? By the way, I already know how to csv out a file and use Perl under *nix to push it to the database. What I am looking for is a way to do this inside of Excel. I already have a DSN set up for my MySQL ODBC driver connection and can query the database from within Excel. Any pointers, articles, or book references would be greatly appreciated. Thanks, Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I import data from a mysql database into excel | Excel Discussion (Misc queries) | |||
Using Excel for MySQL database import | Excel Discussion (Misc queries) | |||
Database records from excel templates | Excel Discussion (Misc queries) | |||
Upload Excel data into online database | Excel Programming | |||
Adding New Records To Excel Database.. | Excel Programming |