VB.net import csv file to MS SQL database
Project details
Read csv files from predefined directory into MS SQL table.
Program must recognize format 1 or 2.
Directory must be polled, time interval configurable.
After import move file to subdirectory ..archive.
Format 1:
See attachment example files Invoice_*
Import all columns from A to HQ (Excel view).
Format 2.
See attachment example file
Start import at line 9, columns “Lieferanten-Code” up to “Sendungsverfolgung-Nr. ”
After import move file to subdirectory ..archive
Awarded to:
Sanjeeva S.
(5.0)
Project budget: $88 USD
budget limits: $30-250 USD
number of bids: 51
average bids: $143
Awarded to:
Sanjeeva S.
(5.0)
Project budget: $88 USD
budget limits: $30-250 USD
number of bids: 51
average bids: $143
Project details
Read csv files from predefined directory into MS SQL table.
Program must recognize format 1 or 2.
Directory must be polled, time interval configurable.
After import move file to subdirectory ..archive.
Format 1:
See attachment example files Invoice_*
Import all columns from A to HQ (Excel view).
Format 2.
See attachment example file
Start import at line 9, columns “Lieferanten-Code” up to “Sendungsverfolgung-Nr. ”
After import move file to subdirectory ..archive
Program must recognize format 1 or 2.
Directory must be polled, time interval configurable.
After import move file to subdirectory ..archive.
Format 1:
See attachment example files Invoice_*
Import all columns from A to HQ (Excel view).
Format 2.
See attachment example file
Start import at line 9, columns “Lieferanten-Code” up to “Sendungsverfolgung-Nr. ”
After import move file to subdirectory ..archive
Skills: .NETVisual Basic
