Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By Syamili VenkatRaman on
Iam new here. I searched everywhere and i am helpless in this situation.
The problem : i need to import data from excel into the database iam using ( MYSQl ). Can someone please guide me how this can be done
Comments
If you using xampp, then
If you using xampp, then
Open phpmyadmin in browser(http://localhost/phpmyadmin) >> Click on import >> Select your format (CSV) >>
Choose your file >> Click on Go
Other wise you can also go with SQLyog GUI
thanks @jackenmail : thanks .
thanks @jackenmail : thanks . how to import programaticaly is what iam looking for
Feeds module
https://www.drupal.org/project/feeds
Import excel to mysql or drupal?
Hi
Do you want to import excel to mysql?
It would be difficult to import data in mysql tables ( may be more than one table involved for one content type ) for drupal.
Programmatically, you can use this as starting point http://bitcookie.com/blog/importing-csv-file-drupal-programmatically-using-batch-api.
EDIT: You can try this also https://www.drupal.org/project/feed_import
Thanks
akki