> 1) Can i directly dump my xls file into mysql table using
> "load data in file". ??
> 2) If answer of First Question is "NO" then
> Can I make my xls(tab seprated) values to csv in the perl
> programme. can I do whole file in one copmmand or I have to
> read it line by line
Hiyas
As for question number 1, there is an easy way to do this. In Excel, you
have the option to save your current spreadsheet as a tab dellimeted txt
file. You do this by issuing the following commands;
- File -> Save As
- Then under 'save as type', choose "Text (Tab delimited)"
When the file is saved, you rename the file to whatever the table name
is that you want these values to be inserted to.
You then use the program called 'mysqlimport' to insert the values of
this text file by using the command;
mysqlimport -u <username> -p <filename>
You will then be asked for the password, enter it and et' voila, you're
there. If there are any warnings, mysqlimport will tell you this when
it's done.
This is a great way to insert values into mysql, and saves a lot of time
for you when working with large databases.
As for your third question, I really don't know I'm afraid, since I
haven't worked that much with mysql+perl.
========================================================================
# Med vennlig hilsen / yours sincerely #
# Jostein Elvaker Haande, aka tolecnal - [EMAIL PROTECTED] #
# Homepage: http://tolecnal.mine.nu #
========================================================================
_______________________________________________
Perl-Unix-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
