alabamaonline.blogg.se

If you copy a dBASE sheet, include the top row that contains the header data.

You can enter a range reference like A1:X500 in the Name Box if you don't want to scroll. You can open a *.dbf dBASE file or many other file types. Open the Calc file that contains the data to be imported to Base.Open a Base file of the database type that you want.Įither create a new Base file using the Database Wizard, or open any existing Base file that is not read-only.If a field in the first valid data row contains a number, the whole column is set to number format, and only numbers, no text, will be shown in that column. Any format information from a spreadsheet file gets lost when importing to Base.įor example, to ensure the first column has a text format, you must make sure that the first field of the first valid data row contains text. The format of every field in the second row determines the format for the entire column. The second row of the file is the first valid data row.

When you import from a text or spreadsheet file, the file must have a first row of header information. You can import text files, spreadsheet files, and your system address book in read-only mode only. Now you can save or export the data to many file types.