Reading CSV through ODBC

[#1]

Hi all,

I'm trying to read CSV files through ODBC but I can't find a way to do that because every time I read a file it isn't split by the comma.

Here is the syntax I'm using:

ODBC CONNECT TO Test;
SQL SELECT *
FROM `C:\USERS\UserName\DESKTOP`\`DataTest.csv`;

where Test is an ODBC source I created and DataTest.csv is the file to be read with the comma as the delimeter.

Does anyone of you have a suggestion?? Thanks!

[danielrozental]

Sorry, don't get it, why do you have to read a CSV using an ODBC connection?

Why can't you read it as a plain file?

[#3]

Hi Daniel, thanks for your answer. I know of the plain loading feature but I do need to use that connection because I'll put that in a QlikView program which loads any kind of data sources then the csv files have to loaded as the other sources. Too long to be explained in details 🙂 .

Thanks again anyway!

[danielrozental]

You should probably check the ODBC definition for the separator.

[#5]

Hi Daniel, yes I already did it.

But it depends on the filename (wildcards can't be used) so I'd have to edit the ODBC source everytime I add a new csv file. I was hoping there was a way to do it in QlikView like we do when we load a plain csv ("delimeter is...").

What do you think?

[Miguel_Angel_Baeyens]

Hello,

That's the plain load Daniel was sepaking of using the preceding load feature, so it creates the script to read it everytime you need it.

Regards.