Ask Your Question
0

how to convert a ods spreadsheet to and odb table

asked 2018-06-22 01:33:04 +0100

sequimbob gravatar image

I have a spread sheet of my inventory and would like to convert it to a data base file

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-06-22 01:58:25 +0100

Ratslinger gravatar image

Hello,

Can be done in multiple ways. Both start with a Base file already created.

  • Create a new table in Base with specs of your data to be copied. Select & copy data from sheet. Right click on created table in Base. Insure table name is correct. Insure Append data is selected. Step through usint Next to verify info or Create depending on your confidence.

  • Basically same as above. Instead of creating table first, data should have heading for use as field names. Copy from sheet & paste into blank table area in Base. First dialog give table name (top of dialog) & insure Definition and data and Use first line as column names are checked. Step through with Next insuring correct field types are to be used (change where necessary).

More information on creating tables can be in the LO docs -> LibreOffice Base Handbook. See chapter 3 - Tables.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-06-22 01:33:04 +0100

Seen: 379 times

Last updated: Jun 22 '18