Database Component

[No-body]

Is there any way to connect to a .CSV file via the ODBC Database Access Component? I like to query the file instead of a regular DB.

 

[VAD_Support]

You can connect to any data source using ODBC. Not sure what query language you would have to use, but maybe it's possible. Please, try it and share with us your experience.
Thanks,

 

[SWSDEV]

After you get your DSN connections in your ODBC correct, this type of sql should work.

"select name, salary from employee.csv e, salary.csv s where e.id=s.id"