Wednesday, March 7, 2012

Linked Server Access

I create a linked server to an Access database with T-SQL is a stored
procedure.
Does anyone know how to create a table in the Access database within the
stored procedure?Probably the only way you're going to be able to do that is to use
Access SQL DDL, which supports the basic CREATE TABLE syntax. You'd
execute an Access action query to do it.
--Mary
On Thu, 15 Apr 2004 08:45:19 -0500, "Joe LeBaron" <Joe@.NoSpam.com>
wrote:

>I create a linked server to an Access database with T-SQL is a stored
>procedure.
>Does anyone know how to create a table in the Access database within the
>stored procedure?
>

No comments:

Post a Comment