Hi Gerard,

What error did you get with SPT parameter? What code do you use to create INSERT statement?

>I have now got all fields, apart from date fields , populating Sql server ok.
>When Inserting the Date field, I've used Dtoc() (the ? was giving an error)
>It creates the record succssfully for good source dates but the date ending up in Sql server table os 01/01/1900 12:00
>