From CSV to SQL Server like a JEDI.

I needed to get some simple sample data from a CSV file into a SQL database, and it occurred to me that I’d seen a nice CSV component several years ago, in the JEDI component set.

In this short video, I’ll demonstrate loading CSV data into a SQL database using the TJvCSVDataset component from JEDI, FireDAC for database connectivity, and a short Delphi pascal function.

(Best viewed full screen)

Print Friendly, PDF & Email
Facebooktwitterredditpinteresttumblrmail

3 Responses

  1. Artiom Vallat says:

    Hi Craig,

    Awesome video, easy to uderstand.
    On my side Im unsing Delphi 7 (old app) and I would like to read a big csv file with over than 180’000 lines.

    I have some questions about the jedi component properties :

    Do I need to specify ALL columns if I dont want the data ?

    I also get an error saying that csv string is too long. It tells me that it’s at a certain line but this line is shorter thant many others.

    Do you have any idea or suggestions ?

  2. paulmcgee1969@gmail.com says:

    You can copy over all same-named fields to a FDMemTable like:

    FDMemTable1.CopyDataSet(JvCSVDataSet1,[coAppend]);

    FDTable might work the same? Could fix the timestamp separately …

Leave a Reply