Arthur Fuller
fuller.artful at gmail.com
Wed Aug 19 05:27:32 CDT 2009
That has got to be the most hilarious syntax I have ever seen. But if it
works, then go for it. But it's a great excuse to give up computing and
instead buy a ladies shoe store LOL.
On Wed, Aug 19, 2009 at 12:37 AM, Collins, Darryl <Darryl.Collins at anz.com>wrote:
> Hah! As usual, after several days of struggling with this, I figure out
> the solution about 2.4 minutes after I emailed the list. Thanks for the
> inspiration - that is what I say :)
>
> The magic syntax is
> DoCmd.TransferDatabase acLink, "Microsoft Access", pcstrDataSource,
> acTable, rsSP("sqlName"), rsSP("tblName"), False, True
>
> Where "pcstrDataSource" is the path and file name.
>
> Cheers
> Darry.
>