VBScript/Powershell to Update .csv based on SQL Query

Simple VBScript or Powershell project to Read .csv file with Header, update "EmployeeID" fields in .csv based on a sql query to determine:

If the Employee ID exists in SQL Database, then replace .csv with EmployeeID from SQL.

If the Employee ID does not exists in SQL Database, replace .csv with Max(EmployeeID)+1 from SQL

Update entire .csv file on these rules.

Kemahiran: Skrip Kekerang

Lihat lagi: powershell update csv, powershell query update csv, vbscript query sql database csv, powershell csv sql, powershell sql exists update, Powershell, update csv file powershell, vbscript update csv sql, powershell update employeeid, on sql, vbscript, SQL Query, sql based, simple csv, update sql file, shell script csv, csv update, sql file csv, sql employee database, employee database sql, database query project, employee database, query project database, project based sql, project sql query

Tentang Majikan:
( 1 ulasan ) Tampa, United States

ID Projek: #1573621

Dianugerahkan kepada:


I am familiar with VBscript. I can get this done in two mandays.

$80 USD dalam 2 hari
(2 Ulasan)

5 pekerja bebas membida secara purata $150 untuk pekerjaan ini


I have experience in scripting. I can do this job.

$120 USD dalam 4 hari
(1 Ulasan)

Hi, I can give you best solution on this

$300 USD dalam 15 hari
(0 Ulasan)

hi sir, I can do your work with powershell.

$200 USD dalam 5 hari
(0 Ulasan)

Dear Sir, I Can do this task using SSIS lookup task boss. Please assign this task for me I can assure 100% completion within 1 hours time. I'm very much familiar with MS SharePoint, MS SQL Server ( SSIS SSAS Lagi

$50 USD dalam sehari
(0 Ulasan)