archana.kulkarni
2nd March 2010, 07:02 PM
For using CSV files as datasource, while specifying the connection URL, the path for the CSV file, has to be specified till its containing folder.
e.g. To access a CSV file ordersmatrix.csv located on my machine at C:\BIPLUS\samples\ordersmatrix.csv
Connection URL: jdbc: odbc: Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=C:\BIPLUS\samples;ImportMixedTypes=Tex t
e.g. To access a CSV file ordersmatrix.csv located on my machine at C:\BIPLUS\samples\ordersmatrix.csv
Connection URL: jdbc: odbc: Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=C:\BIPLUS\samples;ImportMixedTypes=Tex t