My SQL and unknown .MDB file

-------------------------------1123156256
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

Hello..and thank you in advance!

I am running Windows XP...and due to an unscrupulous hardware vendor who
didn't install Microsoft Access in the preconfigured computer that was shipped
to me (Access was paid for)....

.....I now have no way of accessing several .mdb files that I need.

I'm pretty clear that MySQL can indeed be used as an alternative to
Microsoft Access for opening these files...but what I am not clear on is whether this
can be done effectively if I am not able to open the .mdb files in the first
place. Meaning, I don't know how any of the data is setup or configured in
the .mdb files....so I wouldn't know how to configure the data "conversion
process" for the files in the MySQL settings.

Geez...I hope I asked this in a clear enough way....and I hope I posted it
on the right list. Apologies if I missed the mark on either....and thank you
again for you help!

CHEERS!

David

-------------------------------1123156256--

RE: My SQL and unknown .MDB file

You need a 3rd party application to convert from Access to MySQL - they
generally run $30 or so on the web (just google "Access to MySQL") I
use one all the time, they work pretty decently.

If you just want to read the MDB file, you can set up an odbc connection
to the file - but you'll have to have a database application or spread
sheet which is capable of importing or viewing data from an odbc source.


-----Original Message-----
From: PROTANUSA@aol.com [mailto:PROTANUSA@aol.com]
Sent: Thursday, August 04, 2005 7:51 AM
To: win32@lists.mysql.com
Subject: My SQL and unknown .MDB file

Hello..and thank you in advance!

I am running Windows XP...and due to an unscrupulous hardware vendor
who
didn't install Microsoft Access in the preconfigured computer that was
shipped
to me (Access was paid for)....

.....I now have no way of accessing several .mdb files that I need.

I'm pretty clear that MySQL can indeed be used as an alternative to
Microsoft Access for opening these files...but what I am not clear on is
whether this
can be done effectively if I am not able to open the .mdb files in the
first
place. Meaning, I don't know how any of the data is setup or configured
in
the .mdb files....so I wouldn't know how to configure the data
"conversion
process" for the files in the MySQL settings.

Geez...I hope I asked this in a clear enough way....and I hope I posted
it
on the right list. Apologies if I missed the mark on either....and thank
you
again for you help!

CHEERS!

David

--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 7/28/2005


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 7/28/2005



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: My SQL and unknown .MDB file

> I'm pretty clear that MySQL can indeed be used as an alternative to
> Microsoft Access for opening these files...but what I am not clear on is
> whether this
> can be done effectively if I am not able to open the .mdb files in the
> first
> place. Meaning, I don't know how any of the data is setup or configured in
> the .mdb files....so I wouldn't know how to configure the data "conversion
> process" for the files in the MySQL settings.

As far as I can understand, you expect MySQL to open MDB files and operate
on them. I believe it's not possible, but I've been away from MySQL for
almost a year, so you should check if such functionality is available.
The alternative, without Access, is using a tool such as EMS MySQL Importer.
Such tools can read the structure of the MDB files and copy existing tables
into a MySQL database.


Helder M. Vieira






--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: My SQL and unknown .MDB file

-------------------------------1123158831
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit


Thank you so much to the providers of the list for making this
available...the folks who put the time in to maintain it...and, from my own little world...

.....Thank you to Jeramie and Helder for the incredibly rapid...and
instructive responses!

Rock on, MySQL!!


CHEERS!

David




In a message dated 8/4/2005 2:17:09 P.M. W. Europe Daylight Time,
hmv@mail.telepac.pt writes:

As far as I can understand, you expect MySQL to open MDB files and operate
on them. I believe it's not possible, but I've been away from MySQL for
almost a year, so you should check if such functionality is available.
The alternative, without Access, is using a tool such as EMS MySQL Importer.
Such tools can read the structure of the MDB files and copy existing tables
into a MySQL database.


Helder M. Vieira





-------------------------------1123158831--