Re: Copy between identcal tables
From: Frank Hickman [MVP] (fhickman_NOSP_at_M_noblesoft.com)
Date: 02/24/05
- Next message: Brendan Reynolds: "Re: Passing form name to generalized procedure"
- Previous message: Frank Hickman [MVP]: "Re: Make all records as changed"
- In reply to: Alexander Baumgart: "Re: Copy between identcal tables"
- Messages sorted by: [ date ] [ thread ]
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.
- Next message: Brendan Reynolds: "Re: Passing form name to generalized procedure"
- Previous message: Frank Hickman [MVP]: "Re: Make all records as changed"
- In reply to: Alexander Baumgart: "Re: Copy between identcal tables"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
