Connecting Tech Pros Worldwide Forums | Help | Site Map

copy 2 collums from db1 to db2

Member
 
Join Date: Mar 2009
Posts: 44
#1: Mar 17 '09
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
Reply


Similar C# / C Sharp bytes