Database Discussion - SQL Server & MS Access

Print Page | Close Window

SQL Server & MS Access

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=3063
Printed Date: 29 March 2026 at 12:52pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Server & MS Access

Posted By: Gary
Subject: SQL Server & MS Access
Date Posted: 27 May 2003 at 9:55am

I have a DTS which ihas a link to an MS Access database and was wondering whether it is possible to create an MS Access Query from within the MS SQL DTS ???

Something along the lines of CREATE QUERY [Queryname] AS SELECT * FROM myTable

Replies:

Posted By: michael
Date Posted: 30 May 2003 at 10:55am

You can query an msaccess database from within a dts package. You just create the connection and query it. I am doing that as I need to transform data between 2 sql servers and cannot go directly I run a truncate table in the access from the dts package.
Are you using the Wizard or the DTS designer?

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Gary
Date Posted: 02 June 2003 at 2:02am

Michael,

I know that it is possible to query an MS Access db from SQL DTS - what I need to know is whether it is possible to manipulate the Access mdb itself (ie create an MS Access Query).

Maybe I didn't make my question clear enough....

In SQL Server (and most, if not all heavyweight rdbms) you can create objects (CREATE TABLE, CREATE VIEW, CREATE INDEX, etc). Is this at all possible with MS Access using SQL ?

Posted By: MorningZ
Date Posted: 02 June 2003 at 8:50am

if you really really want to know the syntax...

take a look at the source code of "TableEditor" ( http://www.2enetworx.com/dev/projects/tableeditor.asp - http://www.2enetworx.com/dev/projects/tableeditor.asp ), because this ASP app can create tables in an access database.. and considering that its 100% asp-based, then the answer to your question is: absolutely yes

just gotta take a little effort and find out "how" :-)

-------------
Contribute to the working anarchy we fondly call the Internet