How to connect to a csv file

[eduardovs]

Long time ago, I used fyireporting for connecting to odbc, but now I can't figure out how to connect to a csv file. I used the wizard, pasted/typed the file name and path in the connection text field. I tested the connection and it said it was ok. But when I pressed the ok button, this error dialog came up: CommandText requires a 'Url=' parameter. Thanks for moving forward with fyireporting.

[majorsilence]

Does anyone want to fix this? It should be an easy fix.

[eduardovs]

The same error occurs in the original fyireporting. After looking at a text example from the original software, I finally figured out that the way to make it work is like this:

• First in the connection tab you choose Text
• Next for the connection text field, enter anything--like "Hello?" If you press test connection, it will say it's successful, because it's not blank.
• Then in the SQL Tab, on the right panel, type the path of your csv like in the following example: Url=C:\myscripts\bvprices.csv;Header=yes

Thanks.