Import excel spreadsheets into a database table

Hi folks,

I need to convert all the columns of the excel spreadsheet into columns of a table in the database. Currently my client has all the users’ particulars in the excel spreadsheet and I need to import them into the database.

Occasional backup of the database is also needed. Thus I was thinking perhaps I can export the particulars from the database to excel.

Basically it is

Excel to DB
DB back to Excel

I have no idea how to get these done, please advise.

Thanks in advance.

Also in #PHP _↴