| SGreen@unimin.com 2006-02-25, 9:43 am |
| --=_alternative 0074A4448525711C_=
Content-Type: text/plain; charset="US-ASCII"
A little less dodgy is to write a VBA routine within Access to do the
filtering. Alternatively, if you don't want to trust access to do it, you
can write a VBScript or JScript routine and run it through the shell (yes,
Windoze has shell scripts, too)
There are all kinds of things you can do.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Daniel Kasak < dkasak@nusconsulting
.com.au> wrote on 02/21/2006 04:13:28
PM:
> George Law wrote:
piping[color=darkred
]
> I could think of a lot of things I could do if this were all running on
> Linux.
>
> Unfortunately the import routine is being triggered from MS Access ...
> and come to think of it, I'm using 'load data infile' and not
> 'mysqlimport', but anyway, you get the idea. AFAIK there is no way to
> trigger anything useful via ODBC. I could write a Perl script, chuck it
> in my cgi-bin folder, and opening Firefox from Access, passing the
> script some pointers to the file. But that's dodgy. I suppose while I'm
> working with Access I'd better get used to dodgy solutions, eh? ;-)
>
> --
> Daniel Kasak
> IT Developer
> NUS Consulting Group
> Level 5, 77 Pacific Highway
> North Sydney, NSW, Australia 2060
> T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
> email: dkasak@nusconsulting
.com.au
> website: http://www.nusconsulting.com.au
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=sgreen@unimin.com
>
--=_alternative 0074A4448525711C_=--
|