Create table from SQL statement

N

nh

I have an access an Access database which needs to get some data from an SQL
server.

I have a long SQL statement which returns the data I need (It references
several tables on the SQL server, otherwise I would have used linked tables)

What I need to do is create a new table using the data from the SQL
statement.

I can create a passthough query using the SQL statement, and it works fine,
but I want to use a 'DSN-less' connection so that it works from any machine
on the network.

Can someone tell me what I have to do to write achieve the following in a
module:

1. Connect to a SQL server via DSN-less connection
2. Execute an SQL statement
3. Save the results to a new table


Thank you.

Nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table Security in Access 2013 1
Page numbering with Merged Document and IF statements 1
Execute SQL Stored Proc from Access 1
Creating a querydef of a stored proc on Sql Server 8
DSN Less Connection 2
Help creating a search form in Access XP 0
Can I use a variable for a table name in an SQL statement using VB 3
Export SQL Statement to Excel 6

Top