execute SQL scripts in access

[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.

 

[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)