Doesn't Excel have ODBC functionality? If so, there is MyODBC. I don't know if it will provide everything you need, but its a simple start.
P -----Brian Harris <[EMAIL PROTECTED]> wrote: ----- To: Annie Law <[EMAIL PROTECTED]> From: Brian Harris <[EMAIL PROTECTED]> Date: 01/28/2004 04:39PM cc: [EMAIL PROTECTED] Subject: Re: Application using mysql, perl, Excel No, it's not a practical solution, but if you used OpenOffice it could be done. You would need to study the architecture of OO though. 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
