Re: Best Design Approach
Posted by: Doll Hargrove
Date: September 05, 2006 04:00AM

Bill:

I am a newbie to MYSQL and your response is truly, truly appreciated!

No, I had not accounted for male and female data to be more than 10 for each entry. But I do get your point!

1) I am currently transcribing the data directly into MYSQL, however, there are people who will be assisting in other states. Thus, I wanted to create an Excel spreadsheet for them to use to import into MYSQL. If this is doable, how should the headings in Excel be labeled to lessen any import issues.

2) Based on my readings, an Excel to MYSQL converter is required. Is this correct?

3) As you probably know, Excel can easily add each male and female entries to together to give a total household count. Can this be imported into MYSQL?

4) Can the database be set up so that the total for for each sex breakdown would add automatically without entering the total amount for each line of info?


Doll

Options: ReplyQuote


Subject
Written By
Posted
September 04, 2006 02:11PM
September 04, 2006 11:23PM
Re: Best Design Approach
September 05, 2006 04:00AM
September 05, 2006 11:20AM
September 07, 2006 08:56AM
September 07, 2006 09:23AM
September 05, 2006 04:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.