topic Reading CSV through ODBC in QlikView

Reading CSV through ODBC

Mon, 25 Oct 2010 13:52:14 GMT

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!

Reading CSV through ODBC

danielrozental — Mon, 25 Oct 2010 16:30:42 GMT

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?

Reading CSV through ODBC

Mon, 25 Oct 2010 16:51:17 GMT

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!

Reading CSV through ODBC

danielrozental — Mon, 25 Oct 2010 17:00:40 GMT

You should probably check the ODBC definition for the separator.

Reading CSV through ODBC

Mon, 25 Oct 2010 17:19:58 GMT

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?

Reading CSV through ODBC

Miguel_Angel_Baeyens — Mon, 25 Oct 2010 17:22:19 GMT

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.