Re: Copy between identcal tables

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Frank Hickman [MVP] (fhickman_NOSP_at_M_noblesoft.com)
Date: 02/24/05


Date: Thu, 24 Feb 2005 04:28:00 -0500


"Alexander Baumgart" <Alexander.Baumgart@siemens.com> wrote in message
news:cvk2vo$hi3$1@mail1.sbs.de...
> Sorry i cant reply to the article so i need to reopen a new thread.
>
> Gerard Leclercq wrote :
>
> The SELECT INTO Statement
> The SELECT INTO statement is most often used to create backup copies of
> tables or for archiving records.
>
> Syntax
> SELECT column_name(s) INTO newtable [IN externaldatabase]
> FROM source
>
> Thx for your help, but i cant use that SELECT INTO because i try to copy
> from a Access DB to a SQL DB ;(
> I create identival tables on Access and the Sql Server and was hoping i
> could simply change the connection set all records to
> change and made a updatebatch.
>
> Mfg Baumgart
>
>

You can create a link in the Access database to the SQL table and use the
INSERT statement to copy the data.

-- 
============
Frank Hickman
Microsoft MVP
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.


Relevant Pages

  • Re: simple query with distinct keyword
    ... it for amost and hour and a half and I cant make it work. ... I am a bit of a newb to SQL, so pardon the 'basicness' of my ... Sux being a total newb. ... I don't care which of the 'dup' records ...
    (comp.databases.ms-access)
  • Re: simple query with distinct keyword
    ... I am a bit of a newb to SQL, so pardon the 'basicness' of my question ... but I still cant seem to get what Im after. ... being a total newb. ... I don't care which of the 'dup' records gets ...
    (comp.databases.ms-access)
  • Re: Update access table to sql table
    ... Probably been answered before however i cant get a specific guide through ... create an update query in access and innerjoin X to Y use its 2 primary keys ... and try to update Field1 from temp table Y it takes about 30mins then bombs ... in sql but i just dont understand why the query cant do it alot quicker.i ...
    (microsoft.public.access.queries)
  • Update access table to sql table
    ... Probably been answered before however i cant get a specific guide through ... create an update query in access and innerjoin X to Y use its 2 primary keys ... and try to update Field1 from temp table Y it takes about 30mins then bombs ... in sql but i just dont understand why the query cant do it alot quicker.i ...
    (microsoft.public.access.queries)
  • Efficiently comparing 2 datasets from different datasources
    ... My task is to perform an update on a dataset retrieved from SQL Server 2000 ... document up to a webserver and that excel document, ... The Excel dataset will contain differences that must be sent up to the SQL ... I found an article that discusses how to do this (cant recall the URL right ...
    (microsoft.public.dotnet.framework.aspnet)