var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to update data from Excel into Access database?
I have developed an Excel Application using mdb file as database.
The problem is, if there is any possibility to update data in database by update statement eg. Update Tabela Set sth=5 where id=5; ?
Because now I have sth like this:
Set baza = OpenDatabase(c:\database.mdb)
Set tabela = baza.OpenRecordset("Tabela", dbOpenDynaset)
If !ID = 5 Then
!ID = 5
!sth = 5
and it take to much time to update all data.
I'm new in database issues in Excel, so I really apreciate any help.
Thanks in advance,