Thanks Alot :)
--- Michael Roush <[EMAIL PROTECTED]> wrote:
> --- 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/
>
Loading Signature....
Cheap umrah packages > www.Almadinah-umrah.com
When you signup for PayPal, you can start accepting credit
card payments instantly. As the world's number one online payment service,
PayPal is the fastest way to open your doors to over 40 million member
accounts worldwide.
Best of all, it's completely Free to sign up!
To sign up or learn more, click here:
__________________________________
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/
