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:

imagemagic add text to image

rem different types of text annotations on existing images rem cyan yellow orange gold rem -gravity SouthWest rem draw text and anno...