Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / General DB Topics / General DB Topics / January 2005

Tip: Looking for answers? Try searching our database.

mySQL vs. Access with Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gary Fritz - 28 Jan 2005 20:01 GMT
I'm helping someone who has a simple simulation model in Excel.  He
wants to expand the model's complexity by adding a lot more data, and I
told him he needed to move to a real database.

He's probably going to keep the basic model calculation in Excel.  
Unfortunately I don't have much database experience so I'm floundering
a bit.  I assume Excel has reasonably transparent links to Access, and
that may be the right way to do it.  Given my choice, though, I'd
rather do it in mySQL.

My question:  what kind of links does Excel have for accessing data in
Access?  Does it have similar links for mySQL?  I've dug around a bit
but all I can find is tools for *converting* Excel <--> mySQL.  I don't
want to convert it, I want to leave the computation in Excel (some
in the spreadsheet, some in VBA) and grab the data out of the database,
in as transparent a method as possible.

Thanks,
Gary
EricF - 29 Jan 2005 05:43 GMT
>I'm helping someone who has a simple simulation model in Excel.  He
>wants to expand the model's complexity by adding a lot more data, and I
[quoted text clipped - 15 lines]
>Thanks,
>Gary

Someone who has done it could provide more help than this. But you should be
able to access MySql thru Excel using on ODBC driver.

Eric
rkc - 29 Jan 2005 22:05 GMT
> I'm helping someone who has a simple simulation model in Excel.  He
> wants to expand the model's complexity by adding a lot more data, and I
[quoted text clipped - 12 lines]
> in the spreadsheet, some in VBA) and grab the data out of the database,
> in as transparent a method as possible.

The purpose of Access is to be a frontend/GUI development platform for
any number of data sources including Jet, MS SQL, Excel, CSV files,
MySQL or any other that can be talked to via ODBC or that an OLEDB
Provider has been written for.

Access can link to Excel files or MySQl tables. You just have to have
the necessary knowledge to do it.

You can talk to a MySQL database from Excel using ADO or DAO, but you
aren't going to be able to do it 5 minutes starting with no clue. You
have to have a working knowledge of VBA, the language used to "script"
MS Office applications.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.