copy 2 collums from db1 to db2

[Meganutter]

hello,

first of all, im incorporating this in a Windows forms app, not sure if i am correct here. excuse me if i am wrong

i am looking for an easy and fast way to copy 2 collums from db1 (dbf file) to db2 (sdf)
i found out that you can use an insert and select in one query but that doesnt seem to work between 2 connections.

example:
INSERT Files (TiffName, TiffPath) SELECT namepart, pathpart FROM filetable

the reason i want to copy is performance, the foxpro file is slow when it reaches bigger sizes.

thanks in advance