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:

test smtp server with powershell

Send-MailMessage -SMTPServer smtp.domain.com -To [email protected] -From [email protected] -Subject "This is a test email" -Body ...