2 January 2024
Shaik IrfanI need to import Excel file in MySQL,is it possible
It’s very much easier.. just to some research on YouTube
Shaik IrfanI tried on YouTube didn't found
Search for converting your excel to cvc file.. and then you will have option to upload in any client
Nikil (🇮🇳)Search for converting your excel to cvc file.. and then you will have option to upload in any client
Or use
MySQL LOAD DATA INFILE
Shaik IrfanAs I know converting Excel into CSV,but my business recruitment is in Excel files in folder which will be daily updated and need to import in mysql
Then go with complete automation from stage one to stage final..
Forget on updating manually into DB everytime
Shaik IrfanMySQL workbench 8.0
Okay.. manually you can do it on that..
If you want to make it automation on daily basis.. I can do it for you..
Shaik IrfanMySQL workbench 8.0
You mean both client and DB are in the same system ?
Or your DB is on some cloud ?