LIBREOFFICE BASE pt2 - IMPORT LIBREOFFICE CALC Spreadsheet in to BASE

[@caotropheus]

Nice tutorials you have here on Libre - database. Please continue your good work, I am learning on how to use databases from you and if you could show us other stuff that would be great

[@LudoBeckers]

I sure will. From what I've seen so far (already checked another video you did) I like your style of presenting things in a clear way. Thanks again :-)

[@shanepiper]

Thanks for the comment. I am in the process of putting together a video on a simple stock control and ordering database. Along with producing an Invoice for customers. Been away on holiday hence the reason I have not done anymore at the moment. Please feel free to subscribe.

[@shanepiper]

I will make another video which will explain this. Keep an eye on my channel towards the end of this week. Thanks for the comments and suggestions.

[@eleven351]

THANKYOU SO MUCH. U LITERALLY SAVED MY LIFE

[@shanepiper]

Apologises for not getting the video done I had intended, I have an error with Libreoffice base and couldn't produce any forms until a fix was released. I will get this done very soon

[@Raylistic]

Good to see another video tutorial from you! I'm just wondering, how do you link this product table to the customer tables? This is so that the user can know which customer bought which products.

[@shanepiper]

With any database like in LibreOffice Base, MySQL, MSSQL etc... when viewing data in the tables format are only viewed in Columns. If want to access the data in human form you will need to create Form and import the data from the table. Does not have rows as field names, only columns. What LibreOffice Base can do for you is optimize your data so that you can have all the Bands in one table, instruments in and other then use a query to merge the data back together with viewed in a form view.

[@shanepiper]

OK I will do a video on how to know what customer brought which product.

[@shanepiper]

Check out some of my other videos they may be of some help.

[@dyslexicdavey]

Another great video. Thanks!

[@LudoBeckers]

From your answer I gather that, before I try importing a spreadsheet in base, I should learn base basics. Thanks for the reply anyway.

[@jenniferwilliams5003]

ok, never mind, after I used your demonstration to take the calc/excel sheets into their own database I than copied those tables over. I tried first to append them but it wouldn't let me so I just went with the first and I'm gonna see how it works from there. But at least I got the information in a table and in the database I need it in. So that's good.

[@shanepiper]

+Jennifer Williams Thanks good. Another way to do it is to have base and calc open. On calc if you left click on the calc sheet name tab and drag, like you would a file in to a folder. Then drop it on to calc it will create a database table for you with all the data. Hope this helps too.

[@shanepiper]

+Jennifer Williams You could try this - kzbin.info/www/bejne/b6Wmn3yaqMyBoqs

[@LudoBeckers]

I want to import a spreadsheet with songtitle, key, composer, band1, band2, instrumentX, instrumentY, sheetmusicBook, page, etc (some 25 fields) where songtitle would be primary key. Importing makes the table alright, I got that far ;-), but the fields are like they were in the spreadsheet - in columns instead of rows. So I'd need to turn that around somehow before (or after?) importing, before I can set a primary key. Is this possible?