I am currently connecting to a Sql Server, using Vb6.
What i am currently doing, is connecting and writing information from a paradox database on my computer to an sql database on a server.
What i would like to do, is write information back to the paradox table, but only certain fields of a particular record.
My problem is, that the fields on my paradox database have spaces between them, and this is causing a problem, eg: Batch Number, but the field on the sql table is ok, saying BatchNo...
This is the sql string i am currently using.
WriteBatch = "INSERT INTO Batch_de" _
& " (Batch Number,Action Date,Receive Date,Debit Total,Credit Total,Entries,User Code,Total Entries,Errors,Release) VALUES " _
& "('" & WBBatchNo & "','" & WBActionDate & "','" & WBCreationDate & "','" & WBDebitTotal & "','" & WBCreditTotal & "'" _
& ",'" & WBNoOfTrans & "','" & WBUserCode & "','" & 0 & "','" & N & "','" & X & "');"
Basically i think the problem is the spaces between the fields?