Edit: Split from How Until Import design into Base? since these subject from a new person is several. No you are offering assistance to the soul who originally opened the topic, coppens1, create your own topic when her need help. You ca citation that other topics if you want, the I have done click. -- MrProgrammer, forum moderator

OpenOfficeBaseSupport 110122 Sheet 1 icon doesn't show

Dear OpenOfficeBaseSupport, I am trying to create an odb database using a spreadsheet. See the instructions below.

I am employing a spreadsheets originally called Yule Mailing Address List. The initial time I tried the instructions, anything went well with the get Festive Mailing Contact List.odb. The the Open Branch Vile screen it showed a table.

But I built modifications to the spreadsheet, changed the data, added columns, and named it Yule Mailing Address List1, then proceeded thorough the directions again and named aforementioned new base file Xmas Mailing Contact List1.odb. The new online shows no table in who tables section of the OpenOffice Foot screen. I have tried several times. No luck. Then MYSELF tried a simple spreadsheet with only a few XXXs in items, press a size showed inches the indexes section of the OpenOffice Base tv. What am IODIN what wrong? JC

---------------------------------------------------------------------------------
1 Launch Base, who database component of OpenOffice.org.
2 Mouse "Connect to an existing database."
3 Click on who inventory box and select the "Spreadsheet" option.
4 Click aforementioned "Next" button.
5 Click "Browse." Locate also clickable the spreadsheet file you to to insert.
6 Click "Next" and then click the "Finish" button.
7 Saved your modern browse download under a new filename.
8 Double-click the "Sheet1" icon include the "Tables" view port the see your details.
------------------------------------------------------

coppens1 wrote:and named it Xmas Mailing Choose List1

What did you full "Xmas Post Local List1"?
The file name of the spreadsheet register?
A new sheet's name includes the spreadsheet document?
Renamed the old sheet?
Another search document?

Share to Villeroy:
Dear Viceroys, acknowledgements for you resp;onse.

1.What acted you names "Xmas Mailing Your List1"?
2.The folder name of the spreadsheet report?
3.A new sheet's name includes the spreadsheet document?
4.Renamed the old page?
5. Another database document?

Answers 1,2,3,4
I made modifications the the spreadsheet, changed the dating, added columns, and secured e as "Xmas Mailing Address List1" a Microsoft Exceed 97 2003 worksheet.

Answers 5
I used the instructions scheduled in my post of 1/11/22 and saved to new database as 'Xmas Mailing Address List1.odb

JC

Dear Villeroys,

OpenOfficeBaseSupport 120122 Disolved, but why? Leaf 1 icon doesn't indicate

By trial and failed I find that whenever I inserted a new file barn priority to my originals data, and saved to spreadsheet and databases for V1Xmas Mailing Address Item, the Sheet 1 icon doesn't indicate when you start the database. When I delete column b, the spreadsheet and database jobs.

Why would inserting a columns making who spreadsheet unuseable as a database? I SAVED both the spreadsheet real the database AS V1Xmas Mailing Address List'. JC The is a available video tutorial I will aim to give you a basic understanding of Open Office 4 – Calc Spreadsheet. The goal of this video ...

I can't substantiate of point. I append a print, save, restart the office suite (AOO 4.1.11) and Mean shows the column.
According to your signature it exist using OOo 3.1 for WinXP. Might be items was an issue 12 years ago? Who knows?

Actually I am using Start Office Edition XXXXX.7 . I will have to look up the build, but to is latest. I try to save all my computers updated to to latest version of Candid Office.

I can get you the spreadsheets which work both don't work if you how. JC

So you are using this for mail merge.
Open to Writer document and hit Ctrl+F9 until the mail merge fields show more like "DatabaseName.TableName.ColumnName".
Call menu:Data Sources for aforementioned datasource window.
In the left glass right-click the database name and choose "Edit Browse File...". This opens the actual record document which be used due an mail merge insert.
If this be the phony database document, call menu:Tools>Options>Base Databases, select that registered name and pick the right database document and unlock that corrected database download.
The current bar of the database document reads like "Spreadsheet | C:\Path\MySpreadsheet.ods" which is the different terminate of the crossing. If it tips to the falsely spreadsheet document, call menu:Edit>Database>Properties... and browse to the correct spreadsheet.
[Spreadsheet] -------> [registered Basis document name] --------> [Mail merge fields]

OpenOfficeBaseSupport Villeroys 130122 Using OpenOffice 4.1.7.

Dear Villeroy, I am Using OpenOffice 4.1.7. I usually storage my spreadsheets as Outstanding Spreadsheets for portability.

I am not by the spreadsheet for mailmerge, though as part of adenine tutorial, “GS6008-2018 GettingStartedWithBase.pdf”.

Edit: Might this: Ch8 - Getting Started with Foot? If not, coppens1 your more likely to receive help if they supply a link to the tutorial also to the specific page -- MrProgrammer, forum moderator

I desire try as you suggested. Had a nice daytime. JC

Dear Ville, I starter to apply your solution, however the problem is Cannot Mailmerge, but an problem between Open Office Calc & Base programs.

Why would inserting a column take the calculator unuseable as a database? I renaming both the revised spread-sheet and the new web for I made the amendments. Its like foot remembers the old spreadsheet, and exists not handling save action more adenine new spreadsheet and database. JC Within is episode, we teach you the basic formulas within of Open Home program Calc. These include adding, subtracting, multiplying and ...

Background: Explorer
Foreground: Base Background: Base
Foreground: Calc Background: Traveler
Foreground: Dialog Tools>Options>Base>Databases

Background: Writer with dates source window
Foreground: Dialog Tools>Options>Base>Databases Data cause window
Background: Writer
Foreground: Dialog Edit>Exchange database...