Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Create table In MS-Access From SQL Server (linked)

Author  Topic 

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2008-04-30 : 12:56:33
Hi,

The scenario is I have linked server with access. I want to check the MS-Access Database table weather the table Exists or Not.
If Exists I have insert the newly updated records. else I have to create a same table and I have to insert the records.

Now my question is how could I check weather the table is exists or not in MS-Access Database and If Not Exists, Then How can I create the new table thru linked server Query

Thanks
--Krishna
   

- Advertisement -