CSV Driver doesn't see columns of csv file
Hi All, help me please to find the reason of such problem: Dashboard_drv = DDT.CSVDriver("C:\\Documents and Settings\\Administrator\\Desktop\\FILES AFTER UPLOAD to COMPARE\\Dashboard.csv"); var...
Forum Discussion
Hi Vova,
From the Using CSV Files as Data Storages topic:
So, most likely, your physical and virtual machines have different CSV delimiters specified in the registry.
From the Using CSV Files as Data Storages topic:
The format of the CSV file is determined by using a schema information file, named Schema.ini, and located in the same folder as the CSV file. Schema.ini can keep information about several files and for each file it provides data for the general format of the file, field names and field types, used character set, delimiter character, and a number of other data characteristics.
...
When the Schema.ini file is not found, the format of the CSV file is defined by the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text registry settings. For instance, the delimiter character is specified by the Format key and can have one of the following values: TabDelimited, CSVDelimited, Delimited(custom_character), FixedLength.
So, most likely, your physical and virtual machines have different CSV delimiters specified in the registry.
