>I need to import a vfp table into sql-server 2000.
>I do the following:
>- export my table with
> CursorToXML("tmptracking", "c:\temp\msdstracking.xml", 1, 2 + 32 + 512, 0, "c:\temp\msdstracking.xsd")
>- import the data as follows:
>BulkLoadObj = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")
>BulkLoadObj.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;Initial Catalog=MSDS ;Data Source=NL9BD770J;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;User Id=sa;pwd=; network library=dbmssocn"
>*'Add Code to set other properties of the XML Bulk Load object as required
>BulkLoadObj.ErrorLogFile = "c:\temp\msdstracking.err"
>BulkLoadObj.IgnoreDuplicateKeys = .T.
>BulkLoadObj.Transaction = .T.
>BulkLoadObj.Execute("c:\temp\msdstracking.xsd","c:\temp\msdstracking.xml")
>BulkLoadObj = NULL
>
>The most interesting part: no error is generated but nothing is imported into sql-server. It does not even generate an error.
>What am I missing here?
Hi Ron, how is live? Long time since we last spoke... Anyways maybe this helps?
You could consider creating a updatable remote view on the SQL table and just simply append from into the remote view. ?
---
Life is like a box of chocolates