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.