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>
- Re: Mathematica and Access