"Anubis" <anubis2003@bluestreem.com.au> wrote in message
news:ucZJcoO1DHA.208@TK2MSFTNGP12.phx.gbl...
> Hello,
>
> I've been trying to work with code to import data from a "flat file"
(.csv)
> into a SQL 2000 table.
>
> I'm not that well versed in SQL and was wondering is it was possible using
> OPENROWSET or something similar?
>
> I've tried using OPENROWSET and encountered the error "Ad hoc access to
OLE
> DB provider 'MSDASQL' has been denied. You must access this provider
through
> a linked server."
>
> Any help or resources to explain the process would be fantastic.
>
> -Steve
>
>

"Michael Otey" <mikeo@teca.com> wrote in message
news:eEOx90a1DHA.2336@TK2MSFTNGP09.phx.gbl...
> If you're trying to upload through an ASP page you don't want to use
> OPENROWSET. That's really for accessing OLE DB data sources. For an
example
> of uploading a file via ASP check out:
>
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnasdj01/html/asp0900.asp
>
> Mike O.
>
>
> "Anubis" <anubis2003@bluestreem.com.au> wrote in message
> news:ucZJcoO1DHA.208@TK2MSFTNGP12.phx.gbl...
> > Hello,
> >
> > I've been trying to work with code to import data from a "flat file"
> (.csv)
> > into a SQL 2000 table.
> >
> > I'm not that well versed in SQL and was wondering is it was possible
using
> > OPENROWSET or something similar?
> >
> > I've tried using OPENROWSET and encountered the error "Ad hoc access to
> OLE
> > DB provider 'MSDASQL' has been denied. You must access this provider
> through
> > a linked server."
> >
> > Any help or resources to explain the process would be fantastic.
> >
> > -Steve
> >
> >
>
>

"Anubis" <anubis2003@bluestreem.com.au> wrote in message
news:%23eXL8Kb1DHA.2396@TK2MSFTNGP09.phx.gbl...
> Hi Mike,
>
> No, actually I wanted to upload data from a flat file (.csv) into a SQL
> Database like to following
>
>
> Flat File (x.csv) contains:
>
> Col1, Col2, Col3
> Value 0, Value1, Value 2,
> Value 0, Value1, Value 2
>
> Then do a command something like the following:
>
> INSERT INTO dbo.table
> SELECT Col1, Col2, Col3
> FROM x.csv
>
> Basically I want to open a rowset to insert into a SQL table but I cannot
> open the rowset from the .csv source through an ASP command.
>
> Any idea's?
>
> Thanks
>
> -Steve
>
>
>
> "Michael Otey" <mikeo@teca.com> wrote in message
> news:eEOx90a1DHA.2336@TK2MSFTNGP09.phx.gbl...
> > If you're trying to upload through an ASP page you don't want to use
> > OPENROWSET. That's really for accessing OLE DB data sources. For an
> example
> > of uploading a file via ASP check out:
> >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnasdj01/html/asp0900.asp
> >
> > Mike O.
> >
> >
> > "Anubis" <anubis2003@bluestreem.com.au> wrote in message
> > news:ucZJcoO1DHA.208@TK2MSFTNGP12.phx.gbl...
> > > Hello,
> > >
> > > I've been trying to work with code to import data from a "flat file"
> > (.csv)
> > > into a SQL 2000 table.
> > >
> > > I'm not that well versed in SQL and was wondering is it was possible
> using
> > > OPENROWSET or something similar?
> > >
> > > I've tried using OPENROWSET and encountered the error "Ad hoc access
to
> > OLE
> > > DB provider 'MSDASQL' has been denied. You must access this provider
> > through
> > > a linked server."
> > >
> > > Any help or resources to explain the process would be fantastic.
> > >
> > > -Steve
> > >
> > >
> >
> >
>
>