From CSV to SQL Server like a JEDI.

by

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)

Facebooktwitterredditpinterestlinkedintumblrmail

3 thoughts on “From CSV to SQL Server like a JEDI.”

  1. 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. 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 Comment