Creating a spreadsheet to be imported into a database. How to input two names at the same address?
The information isbeing entered into an OpenOffice spreadsheet. A problem I'm having is some residence have two separate first and last names. If I input these into the spreadsheet separately, when print mailing labels I'll get two labels. How can I input them into the sheet so this doesn't happen? Forward thinking, how would I input them so that when it comes time to import into a database I'm able to include both names into one database entry? Thanks in advance!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ltlbearand3
Katie & Jim have given you some good items to consider. If those work, great. If not, we would need to have more details about your data or, better yet, see a sample of your Calc Document (Open Office Spreadsheet) to be able to give more specific advice. If you upload the document, just make sure to use dummy data and not to upload real names and addresses.
ASKER
Katie - Creating from scratch yes. Manually entering the information. I think Jim's answer is about the same as yours but with more detail.
Thank you both!
Thank you both!