SoFunction
Updated on 2025-03-03

How to operate Access database through odbc in go language

package main;
import (
 "fmt"
 "database/sql"
 _"odbc/driver"
)
func main(){
 conn,err := ("odbc","driver={Microsoft Access Driver (*.mdb)};dbq=d:\\");
 if(err!=nil){
  ("Connecting Error");
  return;
 }
 defer ();
 stmt,err := ("select * from test");
 if(err!=nil){
  ("Query Error");
  return;
 }
 defer ();
 row,err := ();
 if err!=nil {
  ("Query Error");
  return;
 }
 defer ();
 for () {
  var id int;
  var name string;
  if err := (&id,&name);err==nil {
   (id,name);
  }
 }
 ("%s\n","finish");
 return;
}