The following was done: From the spreadsheet the block of cells was copied to the clipboard. The database was opened. The Table icon in the left Database pain was clicked. Table1 appeared in the right Table pain. Table1 was clicked and the clipboard was pasted. The Copy table window appeared and Table1 was in the Table name box. Under Options only Append data was selected. Next was clicked. The Assign columns window appeared. in the Source table (box or column) price was at the top row and name was on the next row. Both had a check-mark before them. The Destination table: Table1 had the same two words in rows one and two (price and name). The third row had Time Stamp and the forth row had ID. Am I in the wizard?
If I Copy the cells from the spreadsheet and right-click > Copy instead of right-click Paste Table1 stays there and nothing else happens. The wizard does not appear on the screen. I prefer to use Copy and Paste instead of Drag & Drop Walter On Fri, Oct 23, 2009 at 11:20 AM, Drew Jensen < [email protected]> wrote: > Walter Hildebrandt wrote: > >> When I in what I think is the "main Base window" there is a pain on the >> left >> named *Database* and there are two pains to the right. The top pain is >> named *Tasks* and the bottom pain is named *Tables*. When I click on >> the *Tables >> icon* that is in the left paid, *Table1* appears in the *Tables* pain. >> When >> I drag two columns of data and drop them on *Table1*, the *Copy >> table*window appears and >> *table2* appears in the *Table name* box. >> >> Maybe I do not know what is and how to get into the "main Base window". >> Anyhow what is wrong? >> >> > > nothing. > > Two choices: > > > 1) Do what I said earlier Drag n Drop > > In this case just change the name of the target table int he wizard from > Table2 to Table1 ... > > > 2) Use copy paste. > Copy your block of cells, > Go to Base, say you want to add them to the end of the table "MyTable". > Hightlight MyTable > Bring up the context menu (right mouse click assuming you have not changed > the defaults) > Select Copy > Now the table name is in the wizard's TEXT BOX for table name. > > Follow the instructions in the wizard. > > > Drew > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
