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

2 Responses

  1. says:

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


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

Leave a Reply