Well, if you go to EM and select a database, you'll see "import data" as an
option in the right pane. Click on that, then click on "Next" and then
select "Text file" from the drop down for "Source"
This is how you can do it while sitting at a SQL7 box. My question is has
anyone developed the script to do it in a CF template.
best, paul
At 12:22 PM 11/22/00 -0500, you wrote:
>Paul:
>
>Now you're talking.
>Can you describe this process to me?
>I am using SQL7, but have never taken advantage of this feature.
>
>Richard
>
>----- Original Message -----
>From: "paul smith" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, November 22, 2000 11:39 AM
>Subject: RE: CSV-to-Query
>
>
> > Anyone have a CF version of CSV-to-Table using SQL7's ability
> > to import a text file?
> >
> > best, paul
> >
> >
> > At 11:07 AM 11/22/00 -0500, you wrote:
> > >Take a look at:
> > >http://support.microsoft.com/support/kb/articles/Q190/1/95.ASP
> > >and
> > >http://support.microsoft.com/support/kb/articles/Q195/9/51.ASP
> > >
> > >~Simon
> > >
> > > >
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > Structure your ColdFusion code with Fusebox. Get the official book at
>http://www.fusionauthority.com/bkinfo.cfm
> >
> > Archives: http://www.mail-archive.com/[email protected]/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Structure your ColdFusion code with Fusebox. Get the official book at
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/[email protected]/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
