|
|
Posted by Erland Sommarskog on 08/08/06 22:18
jc (jc_usernet@aanet.com.au) writes:
> Hello. I want to ask about the possibility of copying both a table
> structure and it's contents from a
> SQL server table to a table within MS access. The problem cannot be
> solve with a permanent table structure at the target location.
> The names of the columns are essentially data with the application and
> so are subject to change. I am targeting a solution using SQL Query
> Manager.
>
> The approach I have tried (with failure) is
> SELECT *
> INTO <linkedserver table>
> FROM <local table>
>
> This should create and copy. However, I am not sure if this is
> achievable with this approach.
While this will copy some of the table properties, it will not carry
over indexes etc. So I don't think that this is a good start. You
should probably get script with CREATE TABLE statemnets that also
include definitions of constraints, keys indexes etc. Bare in mind that
Access and SQL Server are quite different, so you may have to do changes
along the way.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|