I tried dragging selected cells and I tried what I think was using block. When I start, there is no data in the table so the columns are empty. The best I was able to do was get somethings into the first row (first cell) of a column. I was dragging a number of rows from the spreadsheet but all the data, if any, appeared only in the first row (cell) of the table.
I have been looking around for information on what I want to do. I came across several places that said moving data from several cells into Base does not work because the data only shows up in one row (one cell) of the table. On Thu, Oct 22, 2009 at 5:59 PM, Drew Jensen < [email protected]> wrote: > Walter Hildebrandt wrote: > >> Using OOo 3.1 on a WindowsXP computer. There is a spreadsheet and a table >> in Base, both of which have two columns with the same headings. How can >> the >> data from the two columns in the spreadsheet be "copied" into the Base >> table? From time to time the "coping" from the spreadsheet into the Base >> table will be done. >> > > Well, basically you will be using Drag n Drop. > > So in one scenario, copy the block of cells you want to move into base. > Drag these to the TABLE object you want to copy them to in the Base file. > When you drop them on the table the Copy Data wizard starts. > One of the options is to APPEND the data to the table. > > Hope that helps. > > Drew > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
