Jump to content
The Uniform Server Community

Connect to Excel workbook?


Heinz Stapff
 Share

Recommended Posts

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. :)

Link to comment
Share on other sites

  • 12 years later...

It sounds like you're trying to link an Excel workbook to your database tables in UniServer. The database you're working with is likely MySQL, which is compatible with Excel through ODBC (Open Database Connectivity). MyISAM, InnoDB, etc., are storage engines within MySQL and don't directly affect how Excel connects to the database. You'll need to set up an ODBC connection for MySQL to link your Excel workbook to the database. Make sure to use the correct MySQL ODBC driver for this setup.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...