So Im not sure how I am going to go about doing this...I want a macro that will pull data off my sql server.
I know that there is the odbc option under the import...but that seems to only work with sql servers that are on the same machine..not web based sql servers (im not sure if thats what mine is, but it doesnt work with phpmyadmin, what ever that is)
...The only way that I get this to work is to go to PHPmyadmin and export my database as an xml file, and then import the xml file into access...works well...except you know high up executive type people, they hate doing stuff on their own, so i need to write some code that will connect to my database on its own...or some how automate the whole downloading process...
is this possible? any questions feel free to ask.
I know that there is the odbc option under the import...but that seems to only work with sql servers that are on the same machine..not web based sql servers (im not sure if thats what mine is, but it doesnt work with phpmyadmin, what ever that is)
...The only way that I get this to work is to go to PHPmyadmin and export my database as an xml file, and then import the xml file into access...works well...except you know high up executive type people, they hate doing stuff on their own, so i need to write some code that will connect to my database on its own...or some how automate the whole downloading process...
is this possible? any questions feel free to ask.