|
 |
asp_databases thread: text file to sql
Message #1 by "Philip Tham" <philipt1@h...> on Fri, 27 Oct 2000 22:21:39 -0500
|
|
What is the best method to take a big multiple fields text file into a
table?
Thanks
Philip
Message #2 by "Dallas Martin" <dmartin@z...> on Sat, 28 Oct 2000 09:16:19 -0400
|
|
It depends on the target SQL field's datatype and what
version of SQL you are using.
In SQL70, char() varchar() have an 8,000 character limit.
Text fields have handle 2GB.
If you are using a progamming interface to your DB, either
ASP or VB, then remember to replace single and double quotes
with either '' or "", else the operatio will fail.
If you are not using ASp/VB, then you can use the DTS services
to import the data.
----- Original Message -----
From: "Philip Tham" <philipt1@h...>
To: "ASP Databases" <asp_databases@p...>
Sent: Saturday, October 28, 2000 1:21 PM
Subject: [asp_databases] text file to sql
> What is the best method to take a big multiple fields text file into a
> table?
>
> Thanks
>
> Philip
>
>
Message #3 by "Philip Tham" <philipt1@h...> on Sat, 28 Oct 2000 13:44:58 -0500
|
|
Dallas,
Thanks. I hasn't decide which way to go yet. You describe the 2 diff way,
1) code it using ASp - A liitle slower but has more control. 2) Using Bulk
Insert (DTS) I am also consider the XML interface.
Have a good week end!
Philip
----- Original Message -----
From: "Dallas Martin" <dmartin@z...>
To: "ASP Databases" <asp_databases@p...>
Sent: Saturday, October 28, 2000 8:16 AM
Subject: [asp_databases] Re: text file to sql
> It depends on the target SQL field's datatype and what
> version of SQL you are using.
>
> In SQL70, char() varchar() have an 8,000 character limit.
> Text fields have handle 2GB.
>
> If you are using a progamming interface to your DB, either
> ASP or VB, then remember to replace single and double quotes
> with either '' or "", else the operatio will fail.
>
> If you are not using ASp/VB, then you can use the DTS services
> to import the data.
>
>
> ----- Original Message -----
> From: "Philip Tham" <philipt1@h...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Saturday, October 28, 2000 1:21 PM
> Subject: [asp_databases] text file to sql
>
>
>
> > What is the best method to take a big multiple fields text file into a
> > table?
> >
> > Thanks
> >
> > Philip
> >
> >
>
|
|
|
View Cart
