- 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)
here is powershell script on how to get list of files from changesets associated with one tfs task
$dllPath = "C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\CommonExtensions\Microsoft\TeamFoundation\...
-
Error:The element 'Schedule' has invalid child element 'RecurrenceRule'. List of possible elements expected: 'Occurring...
-
$z = Import-Csv zerotrac.csv $nums = Import-Csv allleetcode.csv $md =@{} #converting one csv into hashmap for quicker search foreac...
-
Here is instruction how to make blinking text in rainmeter: 1.right click and select " Edit skin " 2.add following code to temp...
No comments:
Post a Comment