Feed Excel Spreadsheet into Database

Discuss the database features

Feed Excel Spreadsheet into Database

Postby yithril » Mon Mar 27, 2017 8:52 pm


I am fairly new to Libre Office but I am learning quickly. I am making a database to make it easier to keep track of parts. The parts have a unique #, a bunch of data. I am looking to do two things:

#1. I know how to make a form so that there is a user friendly way of letting someone else input data and then have it inputted into the database. However, sometimes the data is given to us in excel format in a spreadsheet which follows a template. Is there some way on the form to allow someone to just select the excel file, and then the computer will read the excel file and input the data into the database based on the headers in the excel file?

#2. Can forms be designed so that the user can include an image?

Thank you!
OpenOffice 3.1 on Windows 8
Posts: 1
Joined: Mon Mar 27, 2017 8:45 pm

Re: Feed Excel Spreadsheet into Database

Postby RusselB » Mon Mar 27, 2017 11:18 pm

#1) In Base start the Database Wizard (starts automatically for me when starting with no file), select Connect to an existing database, in the dropdown box select Spreadsheet, follow the rest of the dialog prompts (responses are system specific)

#2) I believe that images can be used as part of a database, but I've not had a need for this ability so I don't know how to do it.
OpenOffice 4.1.6 and LibreOffice on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Posts: 5075
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Feed Excel Spreadsheet into Database

Postby Villeroy » Tue Mar 28, 2017 12:56 am

Do NOT connect to the existing spreadsheet.
Create a new emtpy database.
Store picture file names in a text field but NOT the pictures.
Link a form's picture control to the text field with the picture file names.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Posts: 26700
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to Base

Who is online

Users browsing this forum: No registered users and 3 guests