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.