If I have a DBC table in FoxPro can I insert from that into an SQL table??

select * from foxtable into sqltable

Does that insert all records from the Fox table into the SQL table????