execute SQL scripts in access

  • Thread starter Thread starter Emilio dabdoub
  • Start date Start date
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.
 
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)
 
Back
Top