Run .sql Script

Does anyone know how I can run a .sql script from access?
(copying the sql code just wont do what i need as access limits the number
of fields where my sql script does the 300+ fields i have)

On Sun, 7 Sep 2008 21:24:03 -0700, Mark <Mark@discussions.microsoft.com>
wrote:

>Does anyone know how I can run a .sql script from access?
>(copying the sql code just wont do what i need as access limits the number
>of fields where my sql script does the 300+ fields i have)

If it's a script in SQL/Server T-SQL, store the SQL text as a query and set
its Passthrough property to True. If you're operating against Access JET (now
known as ACE) tables, the tables and queries based on the tables are limited
to 255 fields.
--

John W. Vinson [MVP]

On Sun, 7 Sep 2008 21:24:03 -0700, Mark
<Mark@discussions.microsoft.com> wrote:

Do you want to run this script against a SQLServer? If so, use the
osql.exe program.

-Tom.
Microsoft Access MVP


>Does anyone know how I can run a .sql script from access?
>(copying the sql code just wont do what i need as access limits the number
>of fields where my sql script does the 300+ fields i have)

Thanks John. However It is more than 255 Fields so i have to use this sql
script.access just doesnt do the job.despite thyat the sql script is way
quicker.

Tom, yes I want to run this .sql script against an SQL server(Using Ms SQL
serverman Studio Express)
I found OSQL.exe file but cannot run it.It flashes up as a commandline then
disappears just as quick. How do I use it?
Thanks
Mark

"Tom van Stiphout" wrote:

> On Sun, 7 Sep 2008 21:24:03 -0700, Mark
> <Mark@discussions.microsoft.com> wrote:
>
> Do you want to run this script against a SQLServer? If so, use the
> osql.exe program.
>
> -Tom.
> Microsoft Access MVP
>
>
> >Does anyone know how I can run a .sql script from access?
> >(copying the sql code just wont do what i need as access limits the number
> >of fields where my sql script does the 300+ fields i have)
>