LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 788
Default how-to use Excel to upload records to a MySQL database?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I import data from a mysql database into excel Tina Excel Discussion (Misc queries) 3 May 18th 06 04:21 AM
Using Excel for MySQL database import inspireme Excel Discussion (Misc queries) 1 January 6th 06 10:59 PM
Database records from excel templates BeeJay Excel Discussion (Misc queries) 4 June 22nd 05 03:02 PM
Upload Excel data into online database DH[_3_] Excel Programming 1 September 30th 03 12:57 AM
Adding New Records To Excel Database.. steve Excel Programming 0 August 18th 03 09:11 PM


All times are GMT +1. The time now is 08:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"