List:General Discussion« Previous MessageNext Message »
From:mos Date:December 31 2008 5:37am
Subject:Re: How to convert Acess 2007 ACCDB file to MySQL?
View as plain text  
At 11:12 PM 12/29/2008, you wrote:
>In the last episode (Dec 29), mos said:
> > Someone has given me an Access 2007 file *.ACCDB and I don't have Access
> > 2007. Is there a (preferably free) way to convert it to CSV or MySQL?
>
>Try the ODBC driver downloadable at
>
>"2007 Office System Driver: Data Connectivity Components"
>http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891
>
>You should then be able to connect to the database via any ODBC-capable
>client (e.g. OpenOffice Base, or even an older version of Access or
>Excel) and export the tables in whetever format you want.

Dan, Jerry & Curtis,
        Thanks for all the help. I had to download Open Office 3.x because 
by v2.4 couldn't open the ACCDB file even with the new Access 2007 ODBC. At 
least now I have something to view the file in. I just love MS's way of 
obsoleting their old file format so they can force you to upgrade their 
product  for more $$$.  Thank goodness MS doesn't make cars! Which reminds 
me of this joke that was circulated a while ago. I still find it funny.

Mike

------------------------------------------
If GM had developed technology like Microsoft, we would all be driving cars 
with
the following characteristics:

1. For no reason whatsoever, your car would crash........

Twice a day.

2. Every time they repainted the lines in the road, you would have to buy a new
car.

3. Occasionally your car would die on the freeway for no reason. You would have
to pull to the side of the road, close all of the windows, shut off the car,
restart! it, and reopen the windows before you could continue. For some reason
you would simply accept this.

4. Occasionally, executing a maneuver such as a left turn would cause your car
to shut down and refuse to restart, in which case you would have to reinstall
the engine.

5. Macintosh would make a car that was powered by the sun, was reliable, five
times as fast and twice as easy to drive - but would run on only five 
percent of
the roads.

6. The oil, water temperature, and alternator warning lights would all be
replaced by a single "This Car Has Performed An Illegal Operation" warning
light.


7. The airbag system would ask "Are you sure?" before deploying.

8. Occasionally, for no reason whatsoever, your car would lock you out and
refuse to let you in until you simultaneously lifted the door handle, 
turned the
key and grabbed hold of the radio antenna.

9. Every time a new car was introd! uced car buyers would have to learn how to
drive all over again because none of the controls would operate in the same
manner as the old car.

10. You'd have to press the "Start" button to turn the engine off.

Thread
How to convert Acess 2007 ACCDB file to MySQL?mos30 Dec
  • Re: How to convert Acess 2007 ACCDB file to MySQL?Dan Nelson30 Dec
    • Re: How to convert Acess 2007 ACCDB file to MySQL?Curtis Maurand30 Dec
    • Re: How to convert Acess 2007 ACCDB file to MySQL?mos31 Dec
  • RE: How to convert Access 2007 ACCDB file to MySQL?Jerry Schwartz30 Dec
  • RE: How to convert Access 2007 ACCDB file to MySQL?Jerry Schwartz30 Dec