How i can acess to csv Objects

[Anonymous]

Hello Guys

I've read the Guide to Access to csv files...

But sth. isn't clear for me , why i Need an txt file ?

I've set up an Connection for CSV and it doesn't work ...

dbc:relique:csv:<U:\\contacts-salesforce.csv>?separator=;

Is it the right Syntax ?

Thanks fo helping

John s.

[PAscal]

could you try with:

jdbc:relique:csv:U:\contacts-salesforce.csv?separator=;

[Anonymous]

Hello Pascal

No it doesnt work ... I've tried to use it on an local drive ... but this seems not

working also ...

The actual command is: jdbc:relique:csv:C:\contacts-salesforce.csv?separator=;

The Full Name of the File: C:\contacts-salesforce.csv

best regards

John s.

[PAscal]

is there any error ?
what is the version of csvjdbc.jar version used ?
the version of SQLeoVQB.jar version used ?

could you send us a screen shot of the datasource definition ?
and a csv file (with no sensitiv data) showing the content of the file (with only 2 ou 3 rows

Thanks

[Anonymous]

Yes there is an error

He said that he cant find the Directory: Java.SQL.Exception:Directory not found
C:\contacts-salesforce.csv\

I use the csvjdbc-1.0-24.jar

I don think that i Need any Screenshot or sth. like that It's just an csv Export from

Outlook contacts.

But if it'll needed ... I'll do so ...

best regards John s.

[PAscal]

oups, you have to specify a directory not a file name !

jdbc:relique:csv:C:\?separator=;

should work