Microsoft Access help (Im tarded)

• derek bomar

  

  so I primarily work in Excel, but I need to develop a DB for a report I am running daily now that has too much info to store in Excel. It's an SAP report I export daily into excel and then I have that file linked to Access to append it to the main data tab, and then I want to link a pivot table to the main db file on another excel file...I know how to do all of this. My question is how do I make my query automatically append to the main data table without going through the design view?
• dlazz

  Here's the thing...Access is annoying and it cost me 100% in my computers class in college.
  
  Hope this helps.
• derek bomar

  

  dlazz;722907 wrote:Here's the thing...Access is annoying and it cost me 100% in my computers class in college.
  
  Hope this helps.

  
  this has helped me infinitely
• derek bomar

  

  I really am a tard...figured it out. Needed to hit save. I suck.
• WebFire

  Haha. I haven't used Access in a long time. Glad you figured it out.
• mucalum49

  

  derek bomar;722958 wrote:I really am a tard...figured it out. Needed to hit save. I suck.

  
  I was going to say wouldn't you go to Design View of the Query and hit Execute or save the file. If you worked for my company, corporate IT would freak out because you export out of SAP into Excel/other systems. Do you use SAP Business Analyzer? I'm in ATL right now learning to write queries for it.
  
  /Nerd Talk lol
• derek bomar

  

  mucalum49;723016 wrote:I was going to say wouldn't you go to Design View of the Query and hit Execute or save the file. If you worked for my company, corporate IT would freak out because you export out of SAP into Excel/other systems. Do you use SAP Business Analyzer? I'm in ATL right now learning to write queries for it.
  
  /Nerd Talk lol

  
  I don't use analyzer a lot but I have a feeling I am going to start to...IT is starting to push it. I work mostly in something called TM1 which is like excel on steroids...Access is like Spanish to me, I know a little bit of it, and if I work at it I am sure I could become pretty good at it, just I never really need to use it day to day so I'm terrible at it.
• j_crazy

  

  my company would shit brickhouses if you tried to export from SAP. that shit don't fly round here.
• derek bomar

  

  j_crazy;723135 wrote:my company would shit brickhouses if you tried to export from SAP. that shit don't fly round here.

  
  
  Why?
• j_crazy

  

  dont know but i asked about it once and they unequivocally denied it, no explanation.
• derek bomar

  

  weird
• ZWICK 4 PREZ

  

  j_crazy;723135 wrote:my company would shit brickhouses if you tried to export from SAP. that shit don't fly round here.

  
  That's weird. I export monthly from SAP for metrics for my boss.