Re: load data from Access to SQL

From: Al Reid (areidjr_at_reidDASHhome.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 08:00:19 -0400

"Andre" <no@spam.com> wrote in message news:uBq392wjEHA.2908@TK2MSFTNGP10.phx.gbl...
> Al,
>
> If I can speak in simplistic terms, what I'd like to do is the following:
>
> insert SQLtable
> select * from AccessTable
>
> Is something like this possible without having to loop through every record
> in my Access table? I'm at the point where I have the Access table in a
> recordset, but am unsure how do the Insert, without having to loop through
> every record.
>
> Thanks, Andre
>
>

Andre,

>From what you have provided, I don't know why DTS will not work for you, but...

This MAY work for you. I have not tried or tested it.

INSERT INTO SQLtable
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
              'Data Source="YourAccessDB.mdb";User ID=Admin;Password=;).AccessTable

For additional info look at the MSSQL BOL.

I hope this helps. 

-- 
Al Reid
How will I know when I get there...
If I don't know where I'm going?

Relevant Pages

  • Re: load data from Access to SQL
    ... If I can speak in simplistic terms, what I'd like to do is the following: ... Is something like this possible without having to loop through every record ... Thanks, Andre ...
    (microsoft.public.vb.database.ado)
  • Re: comma puzzle
    ... Perl-style loop ... variable $i is scoped to (all iterations of) the for loop; ... Why do the poets of the present not speak of it? ...
    (comp.lang.perl.misc)
  • Re: Jump Take offs
    ... Being taught the loop as we speak (without any success to report as ...
    (rec.sport.skating.ice.recreational)
  • Re: What Jayne will be missing at Andres wedding.
    ... pandora wrote: ... There is no serious discussion possible in any thread in which Andre is ... His behavior on this newsgroup is quite sufficient to show his ... Do you allow him to speak at you? ...
    (soc.men)
  • Re: What Jayne will be missing at Andres wedding.
    ... pandora wrote: ... There is no serious discussion possible in any thread in which Andre is ... His behavior on this newsgroup is quite sufficient to show ... Do you allow him to speak at you? ...
    (soc.men)