PHPMyAdmin Import : Says Successful but 0 rows added

xoox

Registered
Sep 17, 2011
2
0
51
cPanel Access Level
Website Owner
Hi

I am having a really tough time importing an excel database into a table on my Cpanel PHPMyadmin page. I have tried with .xls, .xlsx, .csv, .xls.zip, .xlsx.zip,etc. but nothing seems to be working.

When tried with .xls or .xlsx, the uploading will happen followed by processing but nothing would happen after that. Now, when I try with the .zip version of the above two docs, this is the message I receive

Import has been successfully finished, 0 queries executed.

The following structures have either been created or altered. Here you can:
  • View a structure`s contents by clicking on its name
  • Change any of its settings by clicking the corresponding "Options" link
  • Edit its structure by following the "Structure" link
Again, zero rows have been imported. Any idea what I am doing wrong?

Thanks a lot.
 

xoox

Registered
Sep 17, 2011
2
0
51
cPanel Access Level
Website Owner
Hi Infopro

The database has 3 tables. Two of them have a similar structure (one is supposed to be the backup to the other) and one more table. One of the similar tables has close to 15,000 rows of data (Each row with 26 columns of string and numeric data).

I was trying to upload a 25,000 row .xlsx sheet (of around 4 MB size) to the second table that has the same structure as the 15000 row table). The 'Sheet1' of the Excel sheet has been renamed with the name of the table. So basically I wanted to "import" this excel sheet into the table. This was created externally and has not been exported/created on the CPanel

Thanks,