Create a query from within Access that attaches to my SQL Server and retrieves the recordset. I'd likely use the same technique I applied in this thread. <BR>2.

Tables are the primary building blocks of a relational database. A table contains rows (or records) of data, and each row is organized into a finite number of columns (or fields). To build a new table ...

How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.

A couple of examples (one via ADO, the other using DAO); with ADO, you are limited to creating the table via an SQL statement, whereas DAO allows you to play with the Access data object model.<BR ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

The SAS/ACCESS engine passes the SQL CREATE TABLE statement and its clauses to the DBMS, which executes the statement and creates the DBMS table. DBCREATE_TABLE_OPTS= applies only when you are ...

Creating New Tables You can create a table from a query using the SQL Editor window or the Query window. In all operating environments, you can create SAS tables and views. In OS/390, you can also ...

To connect to an Access database using SQL, you first need to create an ODBC (Open Database Connectivity) data source that points to the Access database. This will allow you to connect to the ...

Microsoft Access software lets you create a small database you can use on your website. You must first create a new database, then create the tables that store the website information. Access is ...