Ohio Chatter
Ohio Chatter

Forums

All Threads Serious Business Sports Politics Archive Pick 'ems Wordio
Log In Create Account

Microsoft Access help (Im tarded)

Home ▸ Archive ▸ Serious Business ▸ Microsoft Access help (Im tarded)
derek bomar's avatar

derek bomar

Senior Member

3,722 posts
Mar 24, 2011 3:18 PM
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?
Mar 24, 2011 3:18pm
M

MontyBrunswick

Mar 24, 2011 3:30 PM
Here's the thing...Access is annoying and it cost me 100% in my computers class in college.

Hope this helps.
Mar 24, 2011 3:30pm
derek bomar's avatar

derek bomar

Senior Member

3,722 posts
Mar 24, 2011 3:39 PM
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
Mar 24, 2011 3:39pm
derek bomar's avatar

derek bomar

Senior Member

3,722 posts
Mar 24, 2011 4:32 PM
I really am a tard...figured it out. Needed to hit save. I suck.
Mar 24, 2011 4:32pm
W

WebFire

Go Bucks!

14,779 posts
Mar 24, 2011 4:58 PM
Haha. I haven't used Access in a long time. Glad you figured it out.
Mar 24, 2011 4:58pm
mucalum49's avatar

mucalum49

Senior Member

1,639 posts
Mar 24, 2011 5:02 PM
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
Mar 24, 2011 5:02pm
derek bomar's avatar

derek bomar

Senior Member

3,722 posts
Mar 24, 2011 7:29 PM
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.
Mar 24, 2011 7:29pm
j_crazy's avatar

j_crazy

7 gram rocks. how i roll.

8,372 posts
Mar 24, 2011 7:32 PM
my company would shit brickhouses if you tried to export from SAP. that shit don't fly round here.
Mar 24, 2011 7:32pm
derek bomar's avatar

derek bomar

Senior Member

3,722 posts
Mar 24, 2011 7:52 PM
j_crazy;723135 wrote:my company would shit brickhouses if you tried to export from SAP. that shit don't fly round here.


Why?
Mar 24, 2011 7:52pm
j_crazy's avatar

j_crazy

7 gram rocks. how i roll.

8,372 posts
Mar 24, 2011 9:03 PM
dont know but i asked about it once and they unequivocally denied it, no explanation.
Mar 24, 2011 9:03pm
derek bomar's avatar

derek bomar

Senior Member

3,722 posts
Mar 24, 2011 9:29 PM
weird
Mar 24, 2011 9:29pm
ZWICK 4 PREZ's avatar

ZWICK 4 PREZ

Senior Member

7,733 posts
Mar 25, 2011 12:49 PM
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.
Mar 25, 2011 12:49pm