Hello, It might be possible to do what you want to do but...I think it will take too much time and, therefore, will be expensive.
As stated by somebody else OpenOffice with ODBC is effectively an interesting solution. I have done it for fun and it works quite well (after the small nightmare of the installation). Therefore I would suggest that you take a look at the product MySQL Manager (URL: http://ems-hitech.com/mymanager/) It is a commercial product, although not too expensive, but one of the bundle seems to be your solution. There is also a 30 days trial version. Note that I never used the product myself but it seems to be a good part of your solution. Bernard PS I am not associated with the company making MySQL Manager, i.e. I am not paid for marketing or selling it. On Wednesday 28 January 2004 16:27, 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
