import statement for external sql file

[Frederik]

Hi all,



I wonder if it is possible to launch an external SQL file (for example like
in PostgresSQL "\i followed by the path of the file". Although I can hardly
imagine this is not possible in MS Access, I was not able to find how. Can
somebody help me out here?



Thanks in advance,

Frederik



Please reply to the group

 

[[MVP] S.Clark]

Launching an external file from Access is easy using the Shell() function.

Getting access to use the SQL file is a different story.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-