General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Best method to 'Append from' a DBF to a SQL table
The issue is some tables reside on MS SQL, and some are local dbf.
The old code (all dbfs) used the "APPEND FROM" command.
That does't work with MS SQL
I currently have something like the following
SQLEXEC(lnHandle, INSERT into sqlTarget Values (m1,m2))
wraped in a loop procssing for each record in the local dbf.
Can I use a single command to bring in or "append" all the recs in a dbf into the MS SQL table.
Any brief illustration would be great.
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only