Delphi XE4 sample (Step by Step how to download data from CSV to SQL Table)
1. Create Table in SQL database as fallows. CREATE TABLE SAMPLE ( STAFF_ID VARCHAR(30), DATEX VARCHAR(50), TIMEX VARCHAR(50), STATUS VARCHAR(50) ) 2. Add database to your form 3. Create connection to data base 4. Add Query ti table and rename as QR1. 5. Create Folder in C:\DataCSV. 6. Create new text file in C:\DataCSV and rename as "Data". 7. Copy below data to text file. 161|9/7/2013|16:59|0 161|9/7/2013|16:59|0 161|9/7/2013|16:59|1 161|9/7/2013|16:59|1 161|9/7/2013|17:0|1 161|9/7/2013|...