|
|
Posted by Erland Sommarskog on 08/09/06 14:20
jc (jc_usernet@aanet.com.au) writes:
> My basic problem with the initial posting is that I can read tables
> from the linked server (the Access .mdb) but cannot create a table with
> the "SELECT * INTO table" statement.
Yeah, the point with my post is that even if you could it would only take
you half-way, so I don't think is a viable route.
But I see now that I misread your message (was tired last night). I figured
you wanted to copy tables from Access to SQL Server when you in fact want
to do it in the opposite direction. And I'm afraid that's an even deader
end. How would SQL Server be able to create tables on an entirely different
engine? The linked server may even be a non-relational data source.
You may want to look at the Import/Export wizards. I have never used them
myself, though.
--
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]
|