- 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.
Friday
convert excel file into sql and import all data
Subscribe to:
Post Comments (Atom)
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...
-
Error:The element 'Schedule' has invalid child element 'RecurrenceRule'. List of possible elements expected: 'Occurring&...
-
Perfect blog post must include following elements (from 1 to 13): 1.Big catchy header in 30px font size 2.First copy of social links and com...
-
SetKeyDelay , 75 , 75 ;Exits AutoHotKey application. $^CapsLock:: ExitApp return ;Pauses AutoHotKey Script. F6:: Pause , Toggle, 1 $x:: ...
No comments:
Post a Comment