Method is the same if you are using calc or excel. Open up the spreadsheet, ctrl-A (to select all the cells), then drag them into the 'table' area of the database window.
The resulting dialog gives you the option of creating a new table (containing the data) or appending the data to an existing table. Have fun.../paul On 11/8/05, Benson Wang <[EMAIL PROTECTED]> wrote: > Dear all > I using OOo 2.0 BASE on Win2000 > I need import data from Excel to BASE > How can I do except copy and paste one by one ? > > Thnks your advice > > Regard > Benson Wang > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
