Jump to content


Photo

Excel workbook connect to database in UniServer D:?


  • Please log in to reply
2 replies to this topic

#1 Heinz Stapff

Heinz Stapff

    Member

  • Member
  • PipPip
  • 80 posts
  • Gender:Male
  • Location:Riberas Del Pilar, Chapala, Jalisco, Mexico
  • Interests:Architecture, AutoCAD,
  • Main OS: Windows 8

Posted 11 May 2012 - 12:42 PM

Wow guys,
I'm not even sure I'm in the right forum? I've created an Excel workbook in mydocuments that I'd like to link to tables in my D: drive UniServer database tables. The Excel documentation points out that you can add a 'Secure Location' to link to but only offers the typical Microsoft database types including 'Oracle' and I was wondering if my database is compatible with those? If not then the documentation points out that you can add a database type. So I need to find out what type of database phpadmin creates and am not sure 'myisam' etc. is applicable. Any advice or direction greatly appreciated. :)

#2 BobS

BobS

    Project Helper

  • Super Moderator
  • PipPipPip
  • 334 posts
  • Location:Santiago Chile
  • Interests:Retiring, computer systems, system design, model railroads....
  • Wiki ID: BobS
  • Main OS: Windows 7

Posted 11 May 2012 - 01:00 PM

If you're not sure which forum, that's OK, we'll figure it out, but DON'T do multiple posts, because that just bloats the Forum and makes more work.

Excel can use ODBC connections. I've not done it for years, so I don't recall how. I also didn't do it with MySQL, but the do have the drivers for Windows.
Google ODBC, read the Wikipedia article, download the drivers from MySQL. That should get you on the path at least.

Regards,
BobS

#3 Heinz Stapff

Heinz Stapff

    Member

  • Member
  • PipPip
  • 80 posts
  • Gender:Male
  • Location:Riberas Del Pilar, Chapala, Jalisco, Mexico
  • Interests:Architecture, AutoCAD,
  • Main OS: Windows 8

Posted 12 May 2012 - 10:06 AM

Thanks BobS , sorry about the bloat. I needed an answer, sooner than latter. Will Google ODBC.




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users