MathGroup Archive 2009

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Re: Mathematica and Access

  • To: mathgroup at
  • Subject: [mg95401] Re: [mg95363] Re: Mathematica and Access
  • From: Murray Eisenberg <murray at>
  • Date: Sat, 17 Jan 2009 05:32:11 -0500 (EST)
  • Organization: Mathematics & Statistics, Univ. of Mass./Amherst
  • References: <gkn5ok$ink$> <>
  • Reply-to: murray at

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:
> Hi,
>> 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:
> ../SystemFiles/Links/DatabaseLink/Examples/publisher.mdb
> 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...
> hth,
> albert
>> 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
>> Ignacio

Murray Eisenberg                     murray at
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