What you mean maybe is the execution of SQL statements in the query window? Yes, it is possible, but I am referring to
the importing of a SQL script/file and then executing it as a "whole" in access? Is that possible?
I can't seem to find that feature in the access 2003 application itself. Where exactly is this feature located?
I am asking if Access can be able to read a simple SQL script file, which contains CREATE TABLE, INSERT or any action statements. I mean, this will came from an external source, which is a script file, not that you will manuall type in the query window of Access itself.
You will be reading it from a file and then executing it in Access? If I am not mistaken, Access hasn't this feature right?
I am sorry if I got you confuse in the first place.
there is no native access function that will import say a MySQL script (*.sql) and run that script.
however MySQL script files are ascii text, so you could very easily write your own function to rerad the script file and execute the appropriate SQL statements. personally I wouldn't attempt to to exectute a series of SQL commnads in one execute statement. in part thats because there is a finite limit to the size of any variable in Access, but you loose controil of where the problem lies (if you issue a series of execute statements you [should] know where the process failed).
However I suspect the main thing that will trip you up is the differences in syntax between MySQL and JET, although they are both SQL tools, they are not 100% compatible to either the standard or each other. to do this I think you will be better off either usign one of the propriatory tools such as dbtools.
If 'all' you want to do is to truck data around.. then persoanlly I'd 'just' export the data form MySQL into a file.. using wahtever tool you can use (mySQL Query Browser, PHPMyAdmin etc) and then import that data into Access.. you can automate this by using a macro or calling a fnction using the windows scheduler.
I think others may be able to give you a better answer if you elaborate on what your requirement is.. what are you actually trying to do, and where is it falling apart right now.