Hi Steve, > What we want to do is export the mysql data from > the BSD box to the desktop, and somehow open the > template and import the data into the correct fields.
There are lots of ways to do this, depending on exactly what you have and what you need. I'd suggest: 1. The native mysql export tools (can be scheduled via cron if needed): http://dev.mysql.com/doc/mysql/en/mysqldump.html 2. phpMyAdmin's export tools: http://sourceforge.net/projects/phpmyadmin/ 3. Installing MyODBC on the server and using the report wizards in MS Access: http://dev.mysql.com/doc/mysql/en/msaccess.html 4. Writing a PHP script to create an Excel spreadsheet directly: http://pear.php.net/package/Spreadsheet_Excel_Writer (2) and (4) would need you to be running Apache and PHP on the BSD box (is it a web server?) - I'm sure there are similar tools available in Perl, Python, or whatever languages you have available, though. Google is your friend :-) HTH Jon -- This message has been scanned for viruses and dangerous content by Swift Internet, and is believed to be clean. ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
