October 14, 2004 at 5:24 am
Hi,
I have procedure in excell and insert from there data to access table. I want to insert always all rows from excell sheet to access table or no rows. Insert work in loop and after last record I use commit, in other case (error) I use error handler - rollback. All works all right only transaction works bad. I thing problem is in connectionstring. How Must I edit connectionstring than transaction between excell and access works all right?
cnct = "Provider = Microsoft.Jet.OLEDB.4.0; "
Which other parametr Must I use for good work.
Thanks you very much.
zdenek
October 18, 2004 at 8:00 am
This was removed by the editor as SPAM
October 20, 2004 at 4:59 am
Can you post some working code so that we get an idea ?
Secondly my guess is about connection, make sure you are using the same connection object. Transactions are based on the connection....
HTH,
Best Regards,
Parag.
October 20, 2004 at 4:59 am
Can you post some working code so that we get an idea ?
Secondly my guess is about connection, make sure you are using the same connection object. Transactions are based on the connection....
HTH,
Best Regards,
Parag.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply