Loading data from csv file in VirtualTable

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
kwak
Posts: 7
Joined: Tue 01 Jan 2013 09:25

Loading data from csv file in VirtualTable

Post by kwak » Fri 20 Jul 2018 10:49

I would like to import a csv file in a VirtualTable.
Unfortunately I receive a access violation at adress 511BCC0B in module 'dbrtl250.bpl'.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Loading data from csv file in VirtualTable

Post by MaximG » Fri 20 Jul 2018 11:36

Currently, VirtualTable supports loading data in VTD and XML format. And the first of them is an internal storage format used by our components. Samples of working with both formats are provided in Demo distributed together with VirtualDAC. In addition to loading from external files, VirtualTable allows you to load data from another dataset using the Assign method: https://www.devart.com/virtualdac/docs/ ... bject).htm
We will consider the possibility of implementing data loading from CSV files. You can leave your suggestions at our UserVoice page :
https://devart.uservoice.com/forums/104 ... top&page=1

kwak
Posts: 7
Joined: Tue 01 Jan 2013 09:25

Re: Loading data from csv file in VirtualTable

Post by kwak » Fri 20 Jul 2018 15:00

OK. Thx. Is there a simple (Devart) function for formatting a xml file to the correct ADO XML scheme which is compatible with VirtualTable?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Loading data from csv file in VirtualTable

Post by MaximG » Mon 23 Jul 2018 10:44

VirtualTable does not support the direct download of the ADO XML scheme (XSD-format). An example of an XML file, the syntax of which is supported by our component can be found in the Demo supplied with VirtualTable.

Post Reply