Results 1 to 3 of 3

Thread: Running SQL on text file?

  1. Jul 6th, 2004, 03:27 AM #1
    sbasak
    sbasak is offline

    Thread Starter
    Fanatic Member sbasak's Avatar
    Join Date
    Aug 2001
    Location
    Globe Trotter
    Posts
    524

    Running SQL on text file?

    Is there any way to run SQL in text file using VB.NET? The file is delimited text.

    Life is a one way journey, not a destination. Travel it with a smile and never regret anything.
    Yesterday is history, tomorrow is a mystery, today is gift - that's why we call it present.
    Reply With Quote Reply With Quote
  2. Jul 6th, 2004, 07:52 AM #2
    salvelinus
    salvelinus is offline
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950
    No.
    You could read the file into a table, then use SQL.
    Reply With Quote Reply With Quote
  3. Jul 7th, 2004, 04:44 AM #3
    plenderj
    plenderj is offline
    Retired VBF Adm1nistrator plenderj's Avatar
    Join Date
    Jan 2001
    Location
    Dublin, Ireland
    Posts
    10,359
    Though with ODBC one can specify, I believe, the data-source can be a text-file...
    Microsoft MVP : Visual Developer - Visual Basic [2004-2005]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width