Database Component

Discussion in 'CRM / Helpdesk / App Integration' started by No-body, Dec 27, 2011.

Thread Status:
Not open for further replies.
  1. No-body

    Joined:
    Aug 19, 2010
    Messages:
    13
    Likes Received:
    0
    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.
     
  2. VAD_Support

    VAD_Support Active Member

    Joined:
    Aug 6, 2009
    Messages:
    690
    Likes Received:
    0
    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,
     
  3. SWSDEV

    SWSDEV Member

    Joined:
    Feb 23, 2008
    Messages:
    256
    Likes Received:
    0
    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"
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Thread Status:
Not open for further replies.