- 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...
-
2010-11-24 Update: Please download latest version of Pidgin , that has this problem fixed , no additional steps required. Here are 3 ways to...
No comments:
Post a Comment