Re: Microsoft Access, SQL and Quark
Re: Microsoft Access, SQL and Quark
- Subject: Re: Microsoft Access, SQL and Quark
- From: Simon Forster <email@hidden>
- Date: Wed, 17 May 2006 15:34:10 +0100
On 17 May 2006, at 13:09, David Bradley wrote:
My task, we have some catalogue data in an Access database and we
want to extract it into separate Quark files depending on the page.
Any ideas?
Is there any good free SQL Query software that let's you connect to
an ODBC database?
Has anyone got the full version of ProSQL and does it work well
with Applescript?
Has anyone done the same task as I'm trying to achieve or something
similar
FWIW, I was pleasantly surprised at how easy it was to install and
configure an ODBC driver under Mac OS X. Pulling in 291 images and
some text data into FileMaker from MySQL work very quickly.
There are a number of SQL libraries available for many scripting
languages (Python, Perl, Ruby et al). You could probably use one of
these with AppleScript to achieve what you want. i.e. Use PythonSQL
(or whatever its name is) to get the data from Access and then slurp
this into Quark using AppleScript.
Unfortunately, I'm a bit work heavy / time light at the moment
otherwise I'd muck around with this further.
ATB
Simon Forster
_______________________________________________________
LDML Ltd, 62 Pall Mall, London, SW1Y 5HZ, UK
Tel: +44 (0)845 257 6086 Fax: +44 (0)70 9230 5247
_______________________________________________________
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden