Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Display Table

Status
Not open for further replies.
JezBullen

JezBullen

Programmer
Dec 11, 2001
23
GB
Hi

May be a simple question but....Does anyone know an SQL statement to run a query, insert results into a table and then open the table automatically. I thought something like CREATE VIEW would work, but doesn't seem to

Many thanks
JB
 
Sort by date Sort by votes
Hello

SQL is a language purely for data manipulation and selection. While there is no problem inserting query results and updating tables, to open a table or run a query you will need VBA code or a macro.

John
 
Upvote 0 Downvote
Hi
Figured as much, but just thought I'd explore the possibility.
Cheers
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
278
Andrzejek
Andrzejek
spartansFC
  • Locked
  • Question
Display Year between 2 dates 1
Replies
1
Views
275
dhookom
dhookom
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
526
lameid
lameid
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
303
Swi
Swi
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
146
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top