Using Microsoft Access to update phplist database

Technical discussion for developers and service providers

Using Microsoft Access to update phplist database

Postby rsjaffe » 12:58am, Sat 07 Jan, 2012

Connecting Microsoft Access to the sql server was fairly simple, once you get through the 32-bit/64-bit issues. I am only using this connection to update some of the user attributes--I'd be careful about doing other things (e.g., adding users)--look carefully at the database structure to ensure that the proper tables get updated.

Step-by-step connection:
  • Determine whether you have 32 or 64 bit version of Windows
  • Determine whether you have 32 or 64 bit version of Access
  • Go to http://dev.mysql.com/downloads/connector/odbc/
  • If you have 32 bit Access, download the 32-bit MSI installer. If you have 64 bit Access, download the 64-bit MSI installer.
  • Run the MSI installer to install the ODBC connector.
  • If you have 32-bit Access on 32-bit Windows, or 64-bit Access on 64-bit Windows, go to control panel, administrative tools, set up data services. If you have 32-bit Access on 64-bit Windows, run c:\windows\sysWOW64\odbcad32.exe with administrator privileges. If you run the wrong bit size administrative tools, you won't be able to find the MySQL driver.
  • On the User DSN tab, Add..., Select Driver (MySQL ODBC 5.x Driver), hit Finish, then you'll come to a menu to set up the actual connection.
  • Now, in Microsoft Access, create a new database, then go to External Data--ODBC Database, select "link to the data source", select "Machine Data Source" in the next dialog, and you should see the connection you set up in the prior step. Select that source, say "ok" and you're good to go.

Wasn't that nice and intuitive? :shock:
rsjaffe
phpLister
 
Posts: 6
Joined: 8:48pm, Fri 14 Oct, 2011

Return to Developers Space

Who is online

Users browsing this forum: No registered users and 2 guests

cron