JICGreg
Technical User
- Mar 14, 2007
- 34
Historically, I have used tableupdate() to update foxpro data to sql. However, I am running up against the 2gb limit and from a prior post it was suggested to use sqlexec() instead of table update. Unfortunately, I have not found anything right on point and being new to this I was hoping for some input
The structure of the sql table and foxpro table are the same. I simply want to put the foxpro data into the sql table as easily as possible. The update command seems to go column by column and since there are a lot of columns, I would rather not do that unless I have to.
I came up with this but not sure if it would work.
Use foxprotablename
SCATTER MEMVAR
sqlexec(connectionstring, 'insert into sqltablename from memvar')
Thanks for any thoughts.
The structure of the sql table and foxpro table are the same. I simply want to put the foxpro data into the sql table as easily as possible. The update command seems to go column by column and since there are a lot of columns, I would rather not do that unless I have to.
I came up with this but not sure if it would work.
Use foxprotablename
SCATTER MEMVAR
sqlexec(connectionstring, 'insert into sqltablename from memvar')
Thanks for any thoughts.