MS query

[Ava]

Hi, there,
I am trying to combine two sheets together by join a
common id. If I pull some of the fields it works fine but
if I want to pull all the fields from both sheets I didn't
get any data. How many fields can I include in MS query?
Thanks for your help.
Ava

 

[Dick Kusleika]

Ava

My guess is 256 combined fields. I couldn't reproduce the problem with a
small number of fields, but if you want to post your SQL statement, maybe
something will jump out. You can edit the query in MSQuery and click the
SQL button to get the statement, or you can go to the VBE (Alt-F11), then to
the Immediate Window (Cntl-G) and type

?Sheet1.QueryTables(1).CommandText

replace Sheet1 and 1 to get the correct External Data table.