Friday

convert excel file into sql and import all data

  • Here are steps how to convert convert excel file into sql and import all data
  • In step 1:Click on Open input file and open excel file
  • Click on Next Step button
  • In step 2:Specify sql database type (sql server, mysql, sqlite)
  • Click on Next Step button
  • In step 3:Click on Save Result file to save SQL script
  • sql script will have create table and insert instructions
  • Run sql script into database tool to export data from excel into database.

excel-to-sql

No comments:

make ubuntu business casual

to make ubuntu business casual - make it black remove background: gsettings set org.gnome.desktop.background picture-options ...