brian
-- This mail composed and sent using Mozilla Thunderbird. (http://www.mozilla.org/projects/thunderbird/)
-----It's a brave, GNU world!(sorry Bill)------ >>>>> http://www.linux.org
OpenSource is aimed at skilled users, not the 3l33T3 war3z crowd. (1f U sp3ll l1k3 th1s, gu3ss wh1ch U R)
Annie Law wrote:
Hi,
I would appreciate help on the following. I would like to create a small application that would involve Excel XP on
Windows 2000, and
perl and mysql on RedHat linux 9.0
The front end of the application will be Excel since it has a lot
of useful functions. Columns from the Excel sheet will be used to
update the mysql database. Data from the mysql database will also
be used to update the Excel sheet.
I am trying to map things out and see if all of the parts in my application will fit together prior to doing
too much developing.
Basically my main concern now is to create the flow of information. There is the Excel workbook part and then there is the UNIX mysql database part.
Writing a shell or perl script in the linux environment that will ftp files from
an external source that will be used to update the mysql database. They will be flat files. I will use perl to parse the data. Then use perl DBI to insert to information
Also using perl DBI to upload information from the Excel sheet (user's personal annotation) Into the database.
The part that I'm not too sure about is how to send the information from the Excel sheet to the database And how to grab the information from the database and update the Excel sheet. On top of that I am using two different operating systems.
Are there some tools in VBA or in perl that I could use to build this bridge?
Is this a practical solution?
Thanks for your help,
--------------------------------- Post your free ad now! Yahoo! Canada Personals
-- Brian Harris Application Developer OptData Inc./ATRS [EMAIL PROTECTED] (501)907.5912
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
