>I have a VFP 9 table. What is the best way to import that in the Pubs database? I have SQL Server 2005 9.00.2407.00.

I use DTS in SQL 2000 for such tasks. I think it was replaced with Integration Services (SSIS) in SQL 2005. You will have to install VFP OLE DB provider on the SQL Server.