Run .sql Script

[Mark]

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)

 

[John W. Vinson]

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.

 

[Tom van Stiphout]

On Sun, 7 Sep 2008 21:24:03 -0700, Mark

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

-Tom.
Microsoft Access MVP

 

[Mark]

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