Excel spreadsheet into a database

Help
, ,
1

Hello everyone,

I would like to ask how I can convert an Excel spreadsheet into a database. I currently have an Excel table and would like to know the steps or process to achieve this.
Thank you very much.

2

Hi @Allen ,
You can follow this step:
1.read excel file to get data table
2.insert to database
“insert into Your Table Name (Column1,Column2,Column3,Column4,Column5,Column6,Column7,Column8,Column9)
values (‘”+row(“Column1 Name”).ToString+“‘,’”+row(“Column2 Name”).ToString+“‘,’”+row(“Column3 Name”).ToString+“‘,’”+row(“Column4 Name”).ToString+“‘,’”+row(“Column5 Name”).ToString+“‘,’”+row(“Column6 Name”).ToString+“‘,’”+row(“Column7 Name”).ToString+“‘,’”+row(“Column8 Name”).ToString+“‘,’”+row(“Column9 Name”).ToString+“’);”
…
regards,

1 Like
3

Thank you. I got it.