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
