Results 1 to 2 of 2

Thread: tab delimted file into sql [RESOLVED]

Hybrid View

  1. #1

    Thread Starter
    Fanatic Member drpcken's Avatar
    Join Date
    Apr 2004
    Location
    devenv
    Posts
    591

    tab delimted file into sql [RESOLVED]

    I have a tab delimited text file, and I need my aspx page to load that file, read it, and everytime it sees a value with a tab after it, to put that value into a sql table. The table will only have one column, and each value i want to move over is just a 10 digit number. ex:

    9343333333 9384828838 3251243666

    Thats it, each space between each number is a tab of course. I know I'll have to do this with a loop, but I need a little help. Getting it into sql is no prob, just preparing the text file is what I'm having trouble getting my head around.

    Thanks again guys!
    Last edited by drpcken; Sep 15th, 2004 at 11:54 PM.

  2. #2

    Thread Starter
    Fanatic Member drpcken's Avatar
    Join Date
    Apr 2004
    Location
    devenv
    Posts
    591
    ok so far so good.

    The only problem i'm having is with my delimiter. Turns out its not a tab, its a break, or a carriage return, equivilent of hitting ENTER to go to the next line.

    but i'm not sure how to tell it its a carriage return. I was using vbTab when I thought it was a tab.

    Thanks!!

Posting Permissions

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



Click Here to Expand Forum to Full Width