From CSV to SQL Server like a JEDI.

Posted by on in Programming

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)



Comments

  • Alexandr Semakov
    Alexandr Semakov Friday, 1 December 2017

    seriously? 2017 already
    XE 10.2
    StreamReader
    StringList

    and you are using Post\Insert\Update (maybe you have Delphi7?)
    have you heard of SQL?

  • Please login first in order for you to submit comments
  • Page :
  • 1

Check out more tips and tricks in this development video: