MS query

  • Thread starter Thread starter Ava
  • Start date Start date
A

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
 
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.
 
Back
Top