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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
