Using SQL Server Script in MS Access

[Vahram]

How do I use (In module or VBA code for a command) the SQL Server Script in MS Access and does it require any changes in the script to make it work in access?

 

[arnelgp]

you google SQL-pass-through Query.
if you want to run Stored procedure from MSSQL (ans #4):

MS Access call SQL Server stored procedure

I have an MS Access application that contains all tables linked to SQL Server, so in MS Access VBA code or query I work with those tables very simple, I access them via name, like [Customers]. Als...

stackoverflow.com

 

[Vahram]

Hi arnelgp.
Thanks for quick respond.
I have found a script to create a calendar for SQL server.
I would like to use it in access. Do I need to make any changes in the script?
How do I use the script in access?

 

[arnelgp]

there are many Calendars here (just search) and no need conversion
since it is purely msa code.