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)
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:-
-
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.
-
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,
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.
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