Computer Science, asked by aryanmandharboss, 1 year ago

How to link python with Ms Access

Answers

Answered by proudyindian9603
0
searsh on google best answer will be avaie...
sory for inconvinence
Answered by ramesh87901
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