This is the reason ADO sucks!!!
ADO has no native table format Like foxpro, SQL Server Access, or Orcale
anytime you want to do anything you need to create another ADO object, then take the new ADO object point it your other ADO object then you can run your new Select statment. but anytime...