One of the first issues which comes to mind is whether the card is a "real" PCMCIA card or Card-Bus. Not saying PCMCIA USB cards are not out there, just that all of the USB cards I've come across are the 32-bit Card-Bus type which will not work in the A1200 or A600 PCMCIA port.
Yeah, the last time I dug into this matter I found out a lot of PCMCIA cards actually have the all-round NEC chip in it (like the Spider USB card). That made me wonder if there could be such thing as a PCMCIA driver. Unfortunately, they're all 32bit cards since it's USB2.0.
There could be a very small possibility of an 16Bit card when you find a USB1.1 interface card. Untill then... hope for a alternative driver.