MySQL-Excel data correlation

2001-02-16 Thread Joe Ferrara
We have a ton of data in MS Excel that I need to put into a Solaris based MySQL dB. The data needs input such that it correlates across several different tables (i.e. I can't just do table dumps). What is the most efficient way to do this? Thanks, Valerie

Re: Excel->MySQL

2001-02-15 Thread Joe Ferrara
I am not a Perl Guru. How would I set up this environment? Or is there another way to go from excel to MySQL? -- Joseph Ferrara Member of the Engineering Staff LOCKHEED MARTIN Naval Electronics & Surveillance Systems -

Duplication Question

2001-02-15 Thread Joe Ferrara
I want to make an exact duplicate (differenet name) of my entire DB for test purposes. My DB is not too large 8 tables, about max 200 records in any table. What is the best way to do this? -- Joseph Ferrara Member of the Engineering Staff LOCKHEED MARTIN