David, JOIN, duh! That "duh" is for me. ;-)
Thank you for taking the time, it actually makes sense to me, explained out like that. I will take a look at the Pivot Table link. Thank you again, very much. Marcus On Sep 2, 2012, at 3:00 AM, David Grugeon <da...@grugeon.com.au> wrote: > Ok Marcus. It is complicated getting these things to wortogether if you have > limited knowledge of any of them > > I pick No 5.to make a start on answering. > > Let assume that we are talking about a dog club database. You might have a > list of dogs like this: > > Table: Dogs > ID - Name - Breed - Sex > 1 Fred Boxer M > 2 Rover Labrador F > 3 Spot Boxer F > > There are many advantages in setting up a separate table called Breeds > > Table: Breeds > ID - Breed > 1 Labrador > 2 Collie > 3 Boxer > > Then your first table would look like this: > > ID - Name - Breed - Sex > 1 Fred 3 M > 2 Rover 1 F > 3 Spot 3 F > > To retrieve a list of names and breeds you use a query based on a join > something like > > Select Dogs.Name, Breeds.Breed from Dogs Join Breeds on Dogs.Breed=Breed.ID; > > (The language may not be quite right but the principles are) > > The relationship (Join can be set up in the database so you do not have to > specify it in the query. > > Now for Q1 > > I would suggest you look at the following from the incredible Chip Pearson > > http://www.cpearson.com/excel/pivots.htm > > I really feel I am not qualified to talk about the database specific > questions so i will leave that for someone else (or perhaps you could ask on > a My SQL forum. > > > On Sunday, 2 September 2012, Marcus Polk wrote: > So, you removed it? > > Complicated or not, someone might know part of a suction or at least point me > in the right direction. > > Thanks, > > Marcus > > On Sep 1, 2012, at 10:38 AM, yogananda muthaiah > <yogananda.mutha...@gmail.com> wrote: > >> Its too complicate .... No hands on experience to solve ur thread. >> >> On Sat, Sep 1, 2012 at 2:43 AM, Marcus Polk <marcus.j.p...@gmail.com> wrote: >> If these questions have been answered elsewhere, the post is too long or you >> basically do not feel like reading it, please feel free to tell me so. I am >> typing it out, in hopes it helps someone. :-) >> >> In all seriousness though, let me say that learning MySQL, SQL Server, Perl, >> Apache, Bugzilla, what ODBC is and Excel programming all at the same time, >> while in the long run will serve me well, is daunting right now. I am >> learning on my own, but thank God this support list is here, otherwise it >> would take me forever. >> >> I am attempting to gather data into Excel (for charting or simple >> spreadsheets) from our MySQL Bugzilla database. The Bugzilla database is >> located on a newtwork server (installation and DB) and is basically farmed >> out, although my company (read "ME") has to manage it. >> >> In order to be able to speak to the server, I had to create and ODBC >> connection, using MySQL connector (don't get me started on trying to >> understand the difference between User DSN, System DSN, ODB files, etc.). >> When attempting to create this connection, I had to connect to the actual >> server as is is not a localhost. I finally figured out that I had to >> designate the name of the server and then got an error that I could not >> conect. >> >> Originally, I thought I could do something like the following; >> >> GRANT USAGE ON *.* TO 'root'@'%' IDENTIFIED BY 'password!'; >> >> However, this did not work. I now believe it is because all of the >> privledges were set as "N". I then created a ROOT user with the same MySQL >> statement, using the IP address of my system (instead of %) and manually >> granted all the permissions, using MySQL Workbench queries. That worked. >> Now, I have 3 ROOT users. The one for "localhost", the one I created with >> "%" and the one I created with "my IP address". >> >> I then attempted to use the Query Wizard in Excel 2010 to bring over what >> info I wanted to see in my spreadsheet. I now have the following questions >> about what I have done. >> >> 1. Does anyone know of a link to completely explain what a Pivot Table is? >> 2. If I switch all of the privledges for the ROOT user I created with "%", >> will I then be able to access the database through Excel, from any system, >> provided that system had the ODBC connection? >> a. Basically, I need someone to be able to click a link and have the data >> they want, spit out into Excel. I won't be running these queries every time. >> 3. How do I delete all of the extra ROOT users I created, without deleting >> the main ROOT? >> a. Is there a way to simply modify the existing ROOT account to work off of >> any other IP address? >> b. Regarding the above, I am assuming it would be more secure, for me to >> create a user other than ROOT and grant that user the permissions needed to >> run the Excel queries. >> 4. If I want to run queries and dump the data into Excel, is it easier to >> run through the Query Wizard,, use VB code, use Excel code or a combination >> of all 3? >> 5. When I did connect to the database and attempted to get the data I wanted >> into Excel, I noticed that some of the data (assigned_to, product_id, >> component_id, etc.) are numbers. Is that because they need to be referenced >> by that number in another table? If so, how do I associate that data without >> the Excel query complaning that they aren't? How do I get the names of the >> items into my spreadsheet, instead of numbers? >> >> I apologize this is long and I don't know if it will even get read, answered >> or even deleted. If anyone can only answer a part of it though, I would >> appreciate any info I could get. Thanks. >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will >> not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in sign > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, > Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not > get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups "MS > EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, > Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not > get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups "MS > EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
