Script untuk mengkonversi file CSV menjadi file SQL

 

Saya membutuhkan script sederhana (VBA/.Net/anything) untuk merubah beberapa file CSV menjadi file SQL. File CSV tersebut berisi data geo. Sebelum file tersebut di konversi, isi file tersebut perlu di rubah terlebih dahulu seperti merubah digit latlong max 8 digit, menambahkan header 'use database' dan menambahan query insert.

Saya lampirkan sample file dan video cara konversi csv ke sql secara manual.

C# VB.Net

Published Budget: Rp 100,001 - 500,000
Finish Days: 3
Published Date: 22/04/2021 08:50:56 WIB
Start Date: 22/04/2021 09:31:08 WIB
Finish Date: 22/04/2021 11:48:16 WIB
Project Status: Closed
Accepted Worker: anlichandra (anlichandra)
Accepted Budget: Rp 100,001
Project Ending: Completed

Project Owner

lutfi_mega
Kab. Bogor
    
10.00/10.00
11 Point
#8,750 dari 323,037
Rated Worker: 10.00/10.00

Fast response

Accepted Worker

anlichandra
    
9.67/10.00
4,580 Point
#49 dari 323,037
Rated Owner: 10.00/10.00

Auto-rated by system.

  User Bids

vickyzaenuriyanto
    
10.00/10.00

anlichandra
    
9.67/10.00

Ariyozi
    
9.89/10.00

Syafrie007
    
9.94/10.00

Recommended Workers

Iswanto

24,736 points
526 projects
    
9.72/10.00

fauzimarjalih

10,838 points
110 projects
    
9.80/10.00

butirpadi

3,730 points
2 projects
    
10.00/10.00

derodevil

3,554 points
26 projects
    
9.46/10.00

appzone

4,063 points
21 projects
    
9.86/10.00

Recommended Services

Pembuatan Program Matlab

Rp 1,500,000
9 sales
    
10.00/10.00

Jasa Model Machine Learning

Rp 500,000
1 sales
    
10.00/10.00

Open Projects

cari software payroll absensi dengan barcode hp

Rp - 0Owner: Husinasmi
Deadline: 7 days

Dicari Pengguna Software VirtualBox

Rp - 0Owner: Senasmi
Deadline: 10 days

Pengelompokan dan visualiasasi data_03

Rp - 0Owner: ariesds
Deadline: 7 days