Re: Re: Mathematica and Access
- To: mathgroup at smc.vnet.net
- Subject: [mg95401] Re: [mg95363] Re: Mathematica and Access
- From: Murray Eisenberg <murray at math.umass.edu>
- Date: Sat, 17 Jan 2009 05:32:11 -0500 (EST)
- Organization: Mathematics & Statistics, Univ. of Mass./Amherst
- References: <email@example.com> <200901161111.GAA14303@smc.vnet.net>
- Reply-to: murray at math.umass.edu
OK, I see how to access the Example databases, including the one that's
in Access format.
But how do I access my own Access .mdb database? When I run the
OpenSQLConnection wizard and specify to use ODBC(DSN), I'm asked to
enter the DSN. What's that? And where do I enter the actual location
of my Access database?
Albert Retey wrote:
>> I have to manage an huge database in Microsoft Access format.
> I have no experience with huge access databases (usually when databases
> get huge I think the database-people try to avoid access, but 'huge'
> might be relative...). Have you looked at the DatabaseLink
> documentation? They have an example about how to handle an access
> database via ODBC there, which does exactly what you seem to need. Just
> search for ODBC in the documentation center. The documentation was
> obviously done with version 5 but it still works with 7, except that the
> example database is now here:
> the interesting thing is, that this works even without access being
> installed. The downside is that some of the examples in the
> documentation don't work, probably since pathes have changed...
>> I'm trying to do the job using Mathematica because hard computational
>> work is involved, but I'm unable to find the right way using
>> Mathematca's help only.
>> Therefore, I export data from .MDB file in a TSV formatted one, precess
>> them, import data in .MDB file again.
>> No doubt, it's a repetitive, slow, tedious method; I would love
>> modify data (as an example, decrease by 10% prices of all books having
>> been hanging for more than an year) directly within Mathematica Front
>> End (or by means of a Kernel batch call).
>> Please can you suggest if it is feasible and, possibly point out a
>> tutorial about that ? Does anyone got a try before ?
>> Thanks for your attension (and apologies for my poor English !!)
>> Best Regard
Murray Eisenberg murray at math.umass.edu
Mathematics & Statistics Dept.
Lederle Graduate Research Tower phone 413 549-1020 (H)
University of Massachusetts 413 545-2859 (W)
710 North Pleasant Street fax 413 545-1801
Amherst, MA 01003-9305
Prev by Date:
Re: How to modify an Excel file
Next by Date:
Re: Re: Solve / NSolve
Previous by thread:
Re: Mathematica and Access
Next by thread:
Re: Mathematica and Access