Create VIEW from SQL Query on a TABLE using VBA

surferxx

Registered User.
Local time
Today, 05:18
Joined
Aug 31, 2006
Messages
12
How can we do this? Can someone pls help? The query should be part of the code. Like create a variable strSQL = "SELECT * FROM ...." and so on

Newbie here :)
 
Yes you can create strings to hold SQL statements but what do you want to do with them? Also, it is much more efficient to use stored querydefs than embedded SQL strings. You should only create SQL strings in VBA if the query can be structurally different each time it runs.
 
by stored querydefs you mean stored procedures right?
 

Users who are viewing this thread

Back
Top Bottom