-
Sep 15th, 2004, 05:46 PM
#1
Thread Starter
Fanatic Member
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.
-
Sep 15th, 2004, 08:12 PM
#2
Thread Starter
Fanatic Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|