This page is one of several trying to help you get the most out of the splendid Open Office. They are 連合した with a larger 始める，決める concentrating on ooBase.

Remember that Open Office, 含むing ooBase, is 解放する／自由な! But don't let that fool you. And it's not new. Big organizations, 政府 and 非軍事の, are 可決する・採択するing it as their 基準 office 控訴... and saving million$, and still Getting The 職業 Done.

There's more about ooBase in the main 索引 to this 構成要素.

This page is "browser friendly". Make your browser window as wide as you want it. The text will flow nicely for you. It is easier to read in a 狭くする window. With most browsers, 圧力（をかける）ing 加える, minus or 無 while the 支配（する）／統制する 重要な (ctrl) is held 負かす／撃墜する will change the texts size. (大きくする, 減ずる, 回復する to default, それぞれ.) (This is more fully explained, and there's another tip, at my 力／強力にする Browsing page.)

Page contents © TK Boyd, Sheepdog ソフトウェア ®, 11/11.

Introduction

This tutorial is not written the way most of the tutorials at this 場所／位置 are written. It 削減（する）s corners. It panders to the "I don't want to understand what I'm doing; I just want the answer" （人が）群がる.

You will be shown the basics of producing a database from a spreadsheet with Open Office. Please read the more 包括的な discussion I've written for you if you find the tutorial on this page insufficient for your wants. That is a "proper" explanation.

Moving data from a spreadsheet to a database

Written using ooBase 見解／翻訳／版 3.2.1 on Windows XP, but things should work the same way in other Open Office 取り付け・設備s.

This is not a "general" answer to moving data from an Open Office spreadsheet to an Open Office database. It is 目的（とする）d at the "what do I click" （人が）群がる who have 演説（する）／住所s in a spreadsheet, and want to print 演説（する）／住所 labels. The first step is to move the contents of the spreadsheet into a database.

We will assume that you have a spreadsheet something like...

The column headings do not need to be in bold, but you should have column headings, and they should be short. (The last one has a space in it... Bad Idea. PostCode would be better, even if not as grammatically 訂正する.)

The contents of each 独房 should be of reasonable length, and 含む／封じ込める nothing "fancy". Open Office is 有能な of 扱うing all sorts of weird and wonderful things, but if you want these "just click this" 指示／教授／教育s to work for you, you have to Keep It Simple.

Don't use commas in the 独房 contents.

変える to database

To 変える that to a database, do the に引き続いて...

Select the 封鎖する of 独房s defined by A1 and F5

Copy them to the clipboard however you like to do that. Ctrl-C is one way.

開始する，打ち上げる the Open Office database. Perhaps the easiest way from here is to go to the spreadsheet's menu 妨げる／法廷，弁護士業, click "とじ込み／提出する | New | Database"

You should see the Database Wizard, two panes: "Steps" and on the 権利 one 長，率いるd "Welcome to the OpenOffice.org Database Wizard"

Elect "Create a new database", click "Next".

In step 2, say "Yes, 登録（する） it", and "After... saved... open... for editing." Click "Finish" to 遂行する／発効させる your choices under step 2

That should open a normal "Save As" dialog. Save it where you wish. Call it what you want. There are good places and 指名するs, but this is the 限られた／立憲的な guide. Bad choices will "work", up to a point.

From the "Save As" dialog, you should be passed on to the Open Office database main 事業／計画（する） 管理／経営 window.

If "（米）棚上げする／（英）提議するs" is not the selected button in the "Database" column at the left, click on "（米）棚上げする／（英）提議するs".

権利-click in the upper left of the lower 権利-手渡す pane(!) (Under the word "（米）棚上げする／（英）提議するs".)

Click "Paste". (If it is not 利用できる, you did not 後継する in copying the data 支援する when you were looking a the spreadsheet.) That should give rise to....

... with buttons across the 底（に届く）, which I edited off to 焦点（を合わせる） on the 必須のs.

The image above shows things ready for the next step. From the default settings, I've 供給（する）d the "（米）棚上げする／（英）提議する 指名する", and ticked the "Create 最初の／主要な 重要な" box.

Click "Next", which should give you....

(Again: I've edited off buttons from across the 底（に届く）)

This dialog is giving you a chance to be selective about which columns from the spreadsheet should be 会社にする／組み込むd as fields in the database. On the left is 利用できる columns. On the 権利, the fields to be created in the database... at the point the screenshot was taken: 非，不，無. You want them all, so click the second button 負かす／撃墜する, the 二塁打 権利-直面するing arrow. You should see all of the column/ field 指名するs move to the 権利 手渡す column. Click "Next".

You probably should, but probably don't have to change the field type for every field except "ID" to "Text[VARCHAR]". (You may find that the field's are already of this type.) You do this by clicking on the field 指名する in the vertical 名簿（に載せる）／表（にあげる） at the 権利, and then working with the field type listbox.

When that's done... click "Create".

That's it! You have created a database （米）棚上げする／（英）提議する from some spreadsheet data!

演説（する）／住所 labels from a database

Now that you have the data in a database, my tutorial on printing labels should help.

This has not been a typical Sheepdog Guides tutorial. It does not 用意する you to do more than follow a "recipe" which will work in 確かな 狭くする circumstances. If you want to learn about Open Office so that you can do more than that, please visit the main （米）棚上げする／（英）提議する of contents page for the Sheepdog Guides Open Office tutorials.

編集（者）の Philosophy

I dislike 'fancy' web 場所／位置s with more 関心 for a flashy 外見 than for good content. For a pretty picture, I can go to an art gallery. Of course, an attractive 場所／位置 WITH content deserves 賞賛する... as long as that pretty 直面する doesn't cost download time. In any 事例／患者....

I am trying to 現在の this 構成要素 in a 判型 which makes it 平易な for you to USE it. There are two 面s to that: The way it is 分裂（する） up, and the way it is 地位，任命するd. See the main 索引 to this 構成要素 for more （警察などへの）密告，告訴（状） about the way it is 分裂（する） up, and the way it is 地位，任命するd.

広告 from page's editor: Yes.. I do enjoy 収集するing these things for you... I hope they are helpful. However.. this doesn't 支払う／賃金 my 法案s!!! If you find this stuff useful, (and you run an MS-DOS or Windows PC) please visit my freeware and shareware page, download something, and 循環させる it for me? Links on your page to this page would also be 高く評価する／（相場などが）上がるd!

PLEASE >>> Click here to visit editor's Sheepdog ソフトウェア (tm) freeware, shareware pages <<< PLEASE

If you liked this ooBase tutorial, see the main 索引 for （警察などへの）密告，告訴（状） other help from the same author.

Editor's email 演説（する）／住所. Suggestions welcomed!     - - -    Want a 場所／位置 hosted, or email? I like 1&1's services.

Page 実験（する）d for 同意／服従 with INDUSTRY (not MS-only) 基準s, using the 解放する／自由な, 公然と accessible validator at validator.w3.org

. . . . . P a g e . . . E n d s . . . . .