importing txt file to SQL with recordset

This is a discussion on "importing txt file to SQL with recordset" within the Classic ASP section. This forum, and the thread "importing txt file to SQL with recordset are both part of the Program Your Website category.



Go Back   Webforumz.com > Main Forums > Program Your Website > Classic ASP

Notices


Closed Thread
 
LinkBack Thread Tools
  #21 (permalink)  
Old Mar 25th, 2005, 20:43
Junior Member
Join Date: Mar 2005
Location: Norway
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
i will try tomorrow thnx alot
  #22 (permalink)  
Old Mar 28th, 2005, 11:22
Junior Member
Join Date: Mar 2005
Location: Norway
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
well seems like the code is working

But my script is used to loop through a HUGE txt file and insert it into a SQL databse and when i use the this solution the script will run for like hours before it is done....

got any other good ide how to solv the problem of inserting 1 field from the text file (that is over 255chrs)? The ones that is under 255chrs i insert with no prob using recordsets...
Closed Thread

Tags
importing, txt, file, sql, recordset

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
recordset/table display Eclipse414 Web Page Design 4 Dec 25th, 2005 21:02
Importing RecordSet to .asp file tolis Classic ASP 8 Nov 23rd, 2005 20:23
ADODB.Recordset error '800a0bb9' grittyminder Databases 2 Jul 15th, 2005 21:09
passing recordset to next page? Monie Classic ASP 1 Sep 25th, 2004 07:53
recordset constants (data types) spinal007 Classic ASP 6 Sep 19th, 2004 07:39


All times are GMT. The time now is 10:03.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43