Re: Excel, External Data
Re: Excel, External Data
- Subject: Re: Excel, External Data
- From: Paul Berkowitz <email@hidden>
- Date: Thu, 22 Jan 2009 10:41:30 -0800
- Thread-topic: Excel, External Data
Title: Re: Excel, External Data
It depends what type of external source. If it's a text file, all the various parameters are available with
open text file
open text file filename unicode text ¬
origin origin ¬
start row integer ¬
data type open text file data type ¬
text qualifier text file text qualifier ¬
consecutive delimiter boolean ¬
tab boolean ¬
semicolon boolean ¬
comma boolean ¬
space boolean ¬
use other boolean ¬
other char unicode text ¬
field info list ¬
decimal separator unicode text ¬
thousands separator unicode text
For FMP, there's
open FileMaker file
and for running existing database queries
get FileMaker criteria
where the direct parameter is an FMP 'query table' (that's a class).
You can also 'set FileMaker criteria' to create a new query.
You can pretty well do everything you can do in the UI, but via different commands for different types of external data.
--
Paul Berkowitz
> From: Justin Laden <email@hidden>
> Date: Thu, 22 Jan 2009 10:40:16 -0500
> To: AppleScript-Users <email@hidden>
> Subject: Excel, External Data
>
> Hi everyone,
>
> I'm trying to pull data from an external data source in Excel--does
> anyone know how to script that?
>
> -Thanks
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> AppleScript-Users mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
> Archives: http://lists.apple.com/archives/applescript-users
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden