Excel 2003 Query problem

[fblair44]

I am bringing data from a Visual Foxpro table. I get the data source created and while still in that Wizard, I can see the tables and the table columns, but when I try to complete the query to limit the rows imported, it will not let me input a value of "T". The column in the table is "T" or "F" to say, does this item fit or not. When I say "tow_plane" = "T", it comes back and says 'column 'T' does not exist. I have tried T, .T. , "T" and get the same error each time.

[Whizbang]

Field names need to be wrapped in brackets.

[tow_plane] = "T"

I don't recommend using the wizard. It is very limited. Cancel out of the wizard and it will take you to a much cleaner looking editing tool.