Ask Your Question
1

can BASE import a database I created using MS Access?

asked 2016-02-23 17:06:42 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I created a database using MS Access about 10 years ago. can this be imported into BASE, ready to go? or do I have to start all over and create a new one in BASE? (which means learning how tio use BASE, and I am not a programmer type)

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2018-10-09 16:23:44 +0200

robaed gravatar image

updated 2018-10-09 16:28:53 +0200

Definitive Answer....Export your MS ACCESS database to .Xls.....what's even "SWEETER" you don't have to even create a table ahead of time to accept the data...Simply Open the .xls in libre calc....copy the data like you see in the video ...open Librebase....then click PASTE....all easy from there

https://www.youtube.com/watch?v=D_W-F...

edit flag offensive delete link more
0

answered 2016-02-27 12:39:18 +0200

peterwt gravatar image

You can not import a MS Access database into Base. You can however get access to the Tables in the MS Access database. there are two ways:-

1) In LO select create a new Base Database. In the wizard select "Connect to an existing database". Select "Microsoft Access" from the drop down list and select the MS Access database file. You will then see the Tables in the MS Access database.

2) If you want to use a Base database stand alone without having it connected to the MS Access file then after creating the connected database as in 1, with that database left open create another new standard Base database. Select each Table in turn in the connected database copy and then paste into the standard database.

In both cases you will need to create new Forms, Reports, and Queries in the base databases as these elements can not be imported from the Access database,

edit flag offensive delete link more

Comments

Re: "1) In LO select create a new Base Database. In the wizard select "Connect to an existing database". Select "Microsoft Access" from the drop down list..."

Microsoft Access is Not an Option listed in Libreoffice Base Ver. 5.1.6.2.

Only JDBC, Oracle JDBC, Thunderbird, Spreadsheet, dBase, Text, mySQL, & ODBC are the options.

Edward2 gravatar imageEdward2 ( 2017-04-06 22:11:15 +0200 )edit
Login/Signup to Answer

Question Tools

3 followers

Stats

Asked: 2016-02-23 17:06:42 +0200

Seen: 11,224 times

Last updated: Oct 09 '18