>my boss wants me to do it via visual basic !!
>aargghhh


Why does he want you to do it like that??

Probably the best thing to do then is to connect to the fox database via ODBC and the SQL through ODBC thenrun a series of selects then inserts. It's not too difficult, just more time consuming.

Good Luck

Mace