[Solved] Totally converting an MS Access DB to Base
-
- Posts: 2
- Joined: Mon May 19, 2008 7:06 pm
[Solved] Totally converting an MS Access DB to Base
I have an MS Access 2002 database that I have converted to Base. Unfortunately, the Base database still depends on the MS Access database; I cannot now delete the Access database. How can I make the converted base database independent of the MS Access database, so I can delete the MDB file?
Last edited by Hagar Delest on Tue Nov 04, 2008 4:46 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
Re: Totally converting an MS Access DB to Base
Create a new .odb file, drag and drop tables from old file to new table area, copy wizard came up, follow it.
Last edited by r4zoli on Tue Nov 04, 2008 3:10 pm, edited 1 time in total.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin
Re: Totally converting an MS Access DB to Base
The only way I know is to export the database from Access into a spreadsheet. Then open the spreadsheet in Calc, select all and copy it to the clipboard. In Base go to tables and paste the data in the area the tables are listed. This should start a new table wizard. Once complete the data now exists in your Base file and the Access file should no longer be needed.
Here is a link with better directions;
http://searchenterpriselinux.techtarget ... 86,00.html
Here is a link with better directions;
http://searchenterpriselinux.techtarget ... 86,00.html
OOo 3.0.X on Ms Windows XP
-
- Posts: 2
- Joined: Mon May 19, 2008 7:06 pm
Re: Totally converting an MS Access DB to Base
Thanks, that works beautifully!r4zoli wrote:Create a new .odb file, drag and drop tables from old file to new table area, copy wizard came up, follow it.
Re: [Solved] Totally converting an MS Access DB to Base
Trying to get the same mission accomplished, but get the error message "column size is required in statement..."
Trying to copy at least one table from an Access 2003 db over to OOBase. Any help appreciated.
Trying to copy at least one table from an Access 2003 db over to OOBase. Any help appreciated.
Open Office 3.1 on Win7 Professional
Re: [Solved] Totally converting an MS Access DB to Base
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin