<div>
Is it possible to put all of the script into a stored procedure. You could then execute the stored procedure via ADODB or even via a pass through query.<br />
<br />
Either that or setup some form of batch job to execute it.<br />
<br />
<br />
Kelvin
</div>


<div>
The sql file would have to be saved into sql server - or Oracle as stored procs.. &nbsp;(I assume that is what the sql file is for).<br />
<br />
With sql server you can use a batch job to run a sql file.<br />
<br />
I'm am not aware of ways to run .sql files against an Access database itself (if that is what your data is stored in).<br />
<br />
You really need to give a little more detail of what your setup is - where the data is stored and so on.<br />
<br />
<br />
Kelvin
</div>


<div>
<blockquote>
(I assume that is what the sql file is for).
</blockquote>
In that case I would request attention and ask moderator to add SQL Server or/and other databases as part of the topics.
</div>


<div>
Can you please confirm that SQL Server is the back end database - or advise if something else.
</div>


<div>
Hello people, <br />
<br />
I need to run the sql file in Access database. <br />
<br />
Not in Microsoft SQL. Sorry for my lack of information
</div>


<div>
Thanks a lot <br />
It helped me very very much
</div>


<div>
You are welcome!<br />
<br />
/gustav
</div>


<div>
<div class="content wysiwyg-content">
Hello guys, <br />
<br />
I'd like if it is possible to open a sql file with sql scripts on it and run all the code. <br />
<br />
If so, how could I do this in access?<br />
<br />
thanks<br />
Alex
</div>
</div>


Hello guys, 

I'd like if it is possible to open a sql file with sql scripts on it and run all the code. 

If so, how could I do this in access?

thanks
Alex

How can I open a Sql file and run all the script in it?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.