--- OwaiZ <[EMAIL PROTECTED]> wrote:
>
> I would like to know how to import excel worksheet on to mysql
> database.
>
> asuming i have same fields in excel and mysql is it possible ?
> thanks
Yes, it is certainly possible, but it can take a bit of trial-and-error.
Using Excel, you can save a file as a .csv file (CSV stands for 'comma
separated values' I believe), which is essentially just a plain text file.
If you are using phpMyAdmin or some such tool, you can use the "Insert
data from a textfile into table" link at the bottom of the table
'structure' view pane. Set the settings for what you need (this is the
part that can take a little trial-and-error, learning just what your
end-of-line marker is and such.) and it will perform all the insert
queries for you.
It is best to make an empty 'test table' with the same structure as the
intended target table and try inserting the values there first, so that
you can fiddle with the end-of-line settings and such until you have it
right. The good part is, once you figure out how MySQL and Excel will
interact on your particular flavors of local OS, Web server OS, etc., you
can transfer Excel 'databases' into MySQL database tables to your hearts
delight!
Michael Roush
[EMAIL PROTECTED]
"The power of the Web is in its universality. Access by everyone regardless of
disability is an essential aspect."
-- Tim Berners-Lee, W3C Director and inventor of the World Wide Web
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
The PHP_mySQL group is dedicated to learn more about the PHP_mySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
