Ubuntu
openoffice.org package

how to copy and paste into database

Asked by Brielle Plump

I have created a data base and want to copy and paste information from my spreadsheet into the database to do a mail-merge. I have followed many sets of instruction and can not figure out a way to get my spreadsheet data into a data base to accomplish this. Any suggestions??? Better yet, solutions?

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Tony Pursell
Solved:
Last query:
Last reply:
Revision history for this message
Best Tony Pursell (ajpursell) said : 		#1

Hi Brielle

This should be easy. Make sure you have the database you want to copy to open and click on Tables.

Open up the spreadsheet and select the data to copy. The first row of the selected data must have column names. Then do Ctrl-C to copy the data to the clipboard.

Go back to the database, and in the Tables window, right click and select Paste. You get a dialog to tell Base what you want to do with the pasted data to create a table (or to add to a existing table).

Tony

PS If this answers your question, please mark it as Solved

Revision history for this message
Tony Pursell (ajpursell) said : 		#2

Of course, you do not need to put data into a database for mail merge. You can use a spreadsheet as a data source.

Tony

Revision history for this message
Brielle Plump (brie) said : 		#3

Thanks Tony Pursell, that solved my question.