MI MB Select using string variable

This may be simple but I can't get MB 6 ( using MI 5.5) to act on the following Dim MySQL as String MySQL = "Population 1" Select * from MyTable Where MySQL No errors - it just does not resolve MySQL and the 'where' is ignored I CAN put an integer variable in place of 1 Dim

MI Mapping ODBC table that has integer X,Y's

I must be missing something here.. Currently, I import tables that use long integers for lat and lon e.g 30123 -80123 I use 'create points' with a multiplier of 0.001 to map the correct location of 30.123 , -80.123 I want to transition to using ODBC to capture the data from Access 2000

A few questions from a MI newbie

I have learned the basics of MI 5.5 and use it almost daily now as part of a performance monitor for our nationwide tracking system. I deal with large files (20Mb +) , so I always convert my data to Tab files before any manipulation. It would really be a timesaver for me to automate my routines