Ernest,
No, there is no provision to "record" a macro in this way. You need to
write the macro in the macro design window. From your description, it
sounds like for a start you would need these actions in your macro:
TransferSpreadsheet
OpenQuery
OpenQuery
TransferText

Signature
Steve Schapel, Microsoft Access MVP
> Hi all,
>
[quoted text clipped - 10 lines]
>
> Ernest
Ernest Lai - 26 Jan 2007 15:12 GMT
worked a treat thanks very much
> Ernest,
>
[quoted text clipped - 20 lines]
> >
> > Ernest