execute SQL scripts in access

E

Emilio dabdoub

Hi, I have a T-SQL script (to create tables and procedures)

is there a way that I can execute it in MS access? as with query analizer
for sql server.
 
V

Van T. Dinh

If you are talking about an JET Tables then I don't think so since T-SQL and
Access/JET SQL have different syntax. Also, Access/JET doesn't have script
(only single SQL statements) or stored procedures.

HTH
Van T. Dinh
MVP (Access)
 
Top