I have a big xlsx file to save into my database. my xlsx file is large almost 160000 rows in it so does anybody have an easy way to import it into my SQL?
I tried to import it using PHPMyAdmin by converting it into CSV file and I also tried
Select Col1, Col7, Col4
From c:\temp\CSV_File
into Table_target (Col22, Col4, Col9)
this gives me an error
Unexpected ordering of clauses. (near "From" at position 104)
also if you know any better ideas please share. thank you for the answer.
