Access Databases Drivers Drivers For

I searched the forum and did not find an answer to this question, I did read the article about cutting and pasting into a new Base document suggested by Kabing in another thread, however Since that machine died I no longer have Access to cut and paste from.

Is there any way to import the Access database file or open an Access.mtb file in Base I can use either a Mac - OSX 10.4.11 (Tiger) or a PC with XP Pro (which is currently running OpenOffice.

Thanks.

First - you can connect to an MDB file directly ( not an import a connection to the mdb tables ) for specifics see.

Open them both and drag and drop tables from the one to other.each time you do the Copy table wizard opens and you can follow the wizard to move the structure and data - there a few catches, but just try it first and if you get hung up on any particular field or whatnot come back and ask.

Most of us have worked with MS- Office for many years and are MORE then willing to be 100 OO citizens.

It has done 99 of everything I need, for the last five years.

I have several 2003 Access databases that I WANT to make ODB databases.

OR at the least retrieve the Tables (long missing Excel spreadsheets).

It would appear that real conversion is not possible, at least in-house.

You are so right - there is no place that you can say FileImportMS Access So - do what I said above for the CONNECTED base file.

Then do FileNewDatabase Finished With both files open, drag the tables from the MS Access - Connected file to the Base Native file.

The table import wizard starts for each, when you are done moving the tables they are imported.

Remember to drop the table during the Drag n Drop to the Tables section in the Base file window.

Is this perfect.not hardly.but it works with some reservations.

What am I missing I am running OOo 2.3 on Kubuntu 7.10.

Access Databases Drivers Drivers For

They will never produce any database drivers drivers for Linux.

I can establish a connection to the.mdb datesource with no problem.

However, when I attempt to drag tables from the connected file to the new OOo base I get one of two error messages.

First, when attempting to copy I am old I need either a unique index or primary key to proceed.

If I answer yes, then I get an error message that says, Unexpected token: in statement CREATE TABLE name of table( If I answer no to creating a primary key I get an error, SQL Status: 22001 Error code: -124 Value too long in statement names of fields VALUES (,,,,,,) I think my fields are simply too long under the second scenario, but if anyone has ideas why theres an issue with the primary key, and whether the absence of a primary key will affect my ability to work with the database file, Id appreciate your responsehelp.

Connecting to the database works, but doesnt appear to allow me to edit the information.

Copying the table into a new Base database brings up the error messages KHall quoted.

When I run Base, the Database wizard pops up and gives me the choice of Creating a new database, opening an existing data base, or Connecting to an existing database.

If I choose the later, then click on Microsoft Access (top of the list), then browse to my Access database and select it.

Access Databases For Mac