exporting data to microsoft access
I am trying to create a database of schools in Devon. I want to include fields such as address, postcode, email, etc. and then export it to microsoft access, in order to create mail shots, is this possible? if so how do I go about it?
Microsoft's developer network's playing with SPARQL, but there's no real interface at your level. If you must go this way - which is not a good idea as everyone's headed away from proprietory solutions towards Open Source structures - try using SPARQL code through a generalised ODBC external data interface, or else within Visual Basic. These interface modules are fairly dumb and if you can hack the login then it shouldn't really notice what language you're using.
I know you can use classic ASP to write data into a .MDB database, it would depend on the data being held and if you wanted to use the ODBC interface. It is old now though.
It's a really outdated method. I'm sure there are much better ways of achieving it now.