outputting structure/design of Append query

S

Sandy

Hello -

I have to map the fields from a bunch of old tables to several new tables.

I would like to output the Append Query designs to an Excel or Word file so
I can document the mapping for my client.

I have tried a regular copy by selecting the columns in the query but the
copy command is not supported.

Any idea how I can do this?

thanks
sandy
 
J

Jerry Whittle

Open the query in design view. Next go to View, SQL View and copy the sql
statement.
 
S

Sandy

Thanks, Jerry -

What I ended up doing is going to the SQL as you suggested,
copying
then pasting the code into MSWord,
doing a SEARCH for ",[space]"
REPLACE with "^t"
copying from Word
then PASTE SPECIAL -> transpose into Excel to get the fields to line up.

A few steps, but better than keying it all in again :)

thanks!
sandy
 
Top