Skip to main content
added 4 characters in body
Source Link
Zero
  • 77.3k
  • 22
  • 153
  • 153

Is there a way by which I can import an excel workbook which has multiple sheets to mysql database into multiple tables?

Which means, lets say

I have an excel workbook with 3 sheets named sheet1, sheet2 sheet3. Headers Headers for each sheet is on the first row.

  Now I need these 3 sheets to be stored as 3 tables  (sheet,sheet2 sheet2,sheet3 sheet3) in the database.

Is there a way to do this using phpmyadmin, php, python or any other?

I know, we can import individual csv sheets. I want to know if batch import works or not

Is there a by which I can import an excel workbook which has multiple sheets to mysql database?

Which means, lets say

I have an excel workbook with 3 sheets named sheet1, sheet2 sheet3. Headers for each sheet is on the first row.

  Now I need these 3 sheets stored as 3 tables(sheet,sheet2,sheet3) in database.

Is there a way to do this using phpmyadmin, php, python or any other?

I know, we can import individual csv sheets. I want to know if batch import works or not

Is there a way by which I can import an excel workbook which has multiple sheets to mysql database into multiple tables?

Which means, lets say

I have an excel workbook with 3 sheets named sheet1, sheet2 sheet3. Headers for each sheet is on the first row. Now I need these 3 sheets to be stored as 3 tables  (sheet, sheet2, sheet3) in the database.

Is there a way to do this using phpmyadmin, php, python or any other?

I know, we can import individual csv sheets. I want to know if batch import works or not

Source Link
Zero
  • 77.3k
  • 22
  • 153
  • 153

Import excel workbook to Mysql database

Is there a by which I can import an excel workbook which has multiple sheets to mysql database?

Which means, lets say

I have an excel workbook with 3 sheets named sheet1, sheet2 sheet3. Headers for each sheet is on the first row.

Now I need these 3 sheets stored as 3 tables(sheet,sheet2,sheet3) in database.

Is there a way to do this using phpmyadmin, php, python or any other?

I know, we can import individual csv sheets. I want to know if batch import works or not