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

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: <gkn5ok$ink$1@smc.vnet.net> <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:
> 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 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

• References:
  • Re: Mathematica and Access
    • From: Albert Retey <awnl@gmx-topmail.de>