Re: Copy between identcal tables

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)
  • 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)
  • Re: prevent developers writting to our SQL DB ?
    ... We cant use much in the way of stored procedures as there is a layer between ... out VB code and SQL that manages the connection that we cant amend. ...
    (microsoft.public.sqlserver.server)