Re: load data from Access to SQL

From: Andre (no_at_spam.com)
Date: 08/31/04 

Date: Mon, 30 Aug 2004 20:52:53 -0700

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

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: Coffee Tourism in Columbia
    ... It's just English and punctuation that throws you for a loop. ... that's a great idea, jack! ... i speak good french, ...
    (alt.coffee)
  • Re: access attributes from record
    ... Is it possible to determine the 'Length of a record, loop ... it an get attribute name/value/type? ... I can't speak for the others on this group---but personally, ... pseudo-Ada code that isn't really Ada at all, ...
    (comp.lang.ada)
Loading