>Anyone has a sample of using OLEDB programmatically to use to download SQL 2000 tables to a FoxPro database?

Well, there's John V. Petersen's "Jump Start..." article on the MSDN web site. This issue was also covered in the book "1,001 Things You Wanted to Know about Visual FoxPro", by Marcia Akins, Andy Kramek and Rick Schummer from Henztenwerke's/