Linux Archive

Linux Archive (http://www.linux-archive.org/)
-   Gentoo User (http://www.linux-archive.org/gentoo-user/)
-   -   Dealing with MS Access files (.mdb) (http://www.linux-archive.org/gentoo-user/153743-dealing-ms-access-files-mdb.html)

09-03-2008 10:41 PM

Dealing with MS Access files (.mdb)
 
I have a file which may or may not have useful info in it (I am trying
to translate US/Canada NPANXX phone numbers into latitude/longitude or
at least city without buying a commercial db). I know almost nothing
of Access otehr than it being some kind of bastardized database. I
guess it runs some form of SQL but I don't even know that.

Does anyone know of a program to convert this .mdb file into something
useful, other than access to Access on a Windows machine? If it truly
is an SQL database, I suppose it would be some kind of dump complete
with table creation , foreign keys, etc. But I can write a script to
deal with that.

--
... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o

Daniel Pielmeier 09-03-2008 10:45 PM

Dealing with MS Access files (.mdb)
 
felix@crowfix.com schrieb am 04.09.2008 00:41:

I have a file which may or may not have useful info in it (I am trying
to translate US/Canada NPANXX phone numbers into latitude/longitude or
at least city without buying a commercial db). I know almost nothing
of Access otehr than it being some kind of bastardized database. I
guess it runs some form of SQL but I don't even know that.

Does anyone know of a program to convert this .mdb file into something
useful, other than access to Access on a Windows machine? If it truly
is an SQL database, I suppose it would be some kind of dump complete
with table creation , foreign keys, etc. But I can write a script to
deal with that.




app-office/mdbtools http://mdbtools.sourceforge.net/ ??

Regards,

Daniel

09-03-2008 11:25 PM

Dealing with MS Access files (.mdb)
 
On Thu, Sep 04, 2008 at 12:45:24AM +0200, Daniel Pielmeier wrote:

> app-office/mdbtools http://mdbtools.sourceforge.net/ ??

Interesting ... I will have a look tonight. Thanks!

--
... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o

"W.Kenworthy" 09-04-2008 03:42 AM

Dealing with MS Access files (.mdb)
 
app-office/mdbtools

BillK


On Wed, 2008-09-03 at 15:41 -0700, felix@crowfix.com wrote:
> I have a file which may or may not have useful info in it (I am trying
> to translate US/Canada NPANXX phone numbers into latitude/longitude or
> at least city without buying a commercial db). I know almost nothing
> of Access otehr than it being some kind of bastardized database. I
> guess it runs some form of SQL but I don't even know that.
>
> Does anyone know of a program to convert this .mdb file into something
> useful, other than access to Access on a Windows machine? If it truly
> is an SQL database, I suppose it would be some kind of dump complete
> with table creation , foreign keys, etc. But I can write a script to
> deal with that.
>


All times are GMT. The time now is 07:55 PM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.