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)

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmail

2 Responses

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