Append Queries returns an error

Hi Stachu,

Thanks for the reply.

I have used Import not Direct Query (in the Connections Setting dialog box).

I have created queries (1 per database) and for each query I have unchecked "enable load", and then created a new append query to append the queries. I then carried out transformations on the appended query and its only when I try and load the ap[pended query that I get the Direct Query error message.

Regards

Peter