Excellent example from Doug Hennig who's working on a better way to upload data to SQL Server in bulk, or as Bob Archer puts it: "A VFP Upsizing Wizard that actually works".
Doug shows the use of SQLXMLBulkLoad, finally a good way to automate uploads through COM.
Basic requirements are to have the SOAP Toolkit and the SQL Server Client Tools. It is easy to use as Doug shows and it sure beats shelling out to bcp.
Well done Doug!
Friday, July 07, 2006
Doug Hennig's sample code on SQLXMLBulkLoad. Great stuff!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment