How to link python with Ms Access
Answers
Answered by
0
searsh on google best answer will be avaie...
sory for inconvinence
sory for inconvinence
Answered by
0
appDB = WScript.CreateObject("ADODB.Connection");
appDB.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Database);//path to database is already defined at the begining of code
str = "SELECT mun.id, mun.alias FROM mun WHERE (mun.alias)='" + municipality + "';";
appRS = appDB.Execute(str);
midOb = appRS("id").Value;
appRS.close;
appDB.close;
#WScript.Echo(alias);
#WScript.Echo(idMun);
#WScript.Echo(mun_code);
Similar questions
English,
6 months ago
Math,
6 months ago
English,
6 months ago
Social Sciences,
1 year ago
Social Sciences,
1 year ago