On Thu, Apr 23, 2009 at 3:57 PM, Dick Hoffman <[email protected]> wrote:
> We have a home-grown "database" supported by a group of QBASIC programs (no > snickering!) that we'd like to convert to OO Base. Our first question is how > can we input a comma delimited sequential file into Base? This file is > actually the backup of a To import a comma delimited file into Base first open it Calc then copy and paste into Base as follows: - Open Calc - Open the comma delimited file - Create valid field names for the Column titles - make sure there is valid data in each column of the first row of data (I haven't seen this documented but have had importing problems if I don't do this) - Select the data range including column titles - Copy the range - Open Base - Select the "Tables" object - Right-click in the Tables area (to the right of the objects list, the lower half of the window) - Select Paste... - For a new table select the "Definition and data" option and be certain to tick the "Create primary key" option otherwise the table cannot be edited - Now create you field definitions and complete the import (I've had to do trial and error on the import many times to get the data accepted or to get the expected results with a field type) Further instructions can be found here ... In Base help select the "Index" tab, enter the following without quotes "importing;databases" and press enter or on the web http://www.linuxbeacon.com/doku.php/articles:ooobaseprimer#importing_data http://searchenterpriselinux.techtarget.com/tip/0,289483,sid39_gci1222186,00.html The Base documentation I've found isn't as complete as the Writer, Calc and Impress documentation. I hope the above is useful.
