Quantcast
Microsoft Access/Excel - Beyond.ca - Car Forums
Results 1 to 13 of 13

Thread: Microsoft Access/Excel

  1. #1
    Join Date
    Sep 2008
    Location
    NE
    My Ride
    Ram 1500, '68 Camaro, S14
    Posts
    1,776
    Rep Power
    30

    Default Microsoft Access/Excel

    Anyone know of someone that is super proficient in these programs? Looking to pay someone to set me something up that can sort Access (a live database) information into excel, track changes etc. Need to know if its possible even i guess.

    Thanks.

  2. #2
    Join Date
    Mar 2003
    Location
    C-Spot
    My Ride
    11sec S14, Lux Family Bus, VQ35HR
    Posts
    2,575
    Rep Power
    40

    Default

    I know Access a bit and how to do most of those things you're describing. But doing those things live or automatically querying, which is what I believe you are describing, from external programs like excel is beyond me.

    It also depends on the size of the database itself and whether it's already built or needs to be built to allow for such queries. I am sure it CAN be done.
    Quote Originally Posted by Yolobimmer View Post
    This quote is hidden because you are ignoring this member. Show Quote
    She wishes it was deep.
    Quote Originally Posted by rage2 View Post
    This quote is hidden because you are ignoring this member. Show Quote
    So deep put her ass to sleep.

  3. #3
    Join Date
    Apr 2008
    Location
    Stampede Central
    My Ride
    is pretty sharp lookin'
    Posts
    2,208
    Rep Power
    28

    Default

    If you have an existing MS Access Database that is actively updated, and you're just looking to query some sort of report, or list of specific things you want to see, your best bet is probably some Tableau or PowerBI interface.

  4. #4
    Join Date
    Sep 2008
    Location
    NE
    My Ride
    Ram 1500, '68 Camaro, S14
    Posts
    1,776
    Rep Power
    30

    Default

    Quote Originally Posted by DonJuan View Post
    This quote is hidden because you are ignoring this member. Show Quote
    I know Access a bit and how to do most of those things you're describing. But doing those things live or automatically querying, which is what I believe you are describing, from external programs like excel is beyond me.

    It also depends on the size of the database itself and whether it's already built or needs to be built to allow for such queries. I am sure it CAN be done.
    I feel like you're a drafter no? Its a live materials database from a model that updates in access, i want converted to a structured BOM... i dont even know if its a thing i just think of stuff then find people smarter than me to tell if it's possible lol

    Quote Originally Posted by jwslam View Post
    This quote is hidden because you are ignoring this member. Show Quote
    If you have an existing MS Access Database that is actively updated, and you're just looking to query some sort of report, or list of specific things you want to see, your best bet is probably some Tableau or PowerBI interface.
    I'm a simpleton, i dont know how to use Tableau or what PowerBI is haha

  5. #5
    Join Date
    Sep 2016
    Location
    Calgary, Ab
    My Ride
    2021 Zonda CRV
    Posts
    935
    Rep Power
    14

    Default

    Quote Originally Posted by JfuckinC View Post
    This quote is hidden because you are ignoring this member. Show Quote
    I feel like you're a drafter no? Its a live materials database from a model that updates in access, i want converted to a structured BOM... i dont even know if its a thing i just think of stuff then find people smarter than me to tell if it's possible lol
    I'm a simpleton, i dont know how to use Tableau or what PowerBI is haha
    If the data is in Access. Then you can hire someone to do Power BI from that. Ive just started to grasp what it is.
    Its a new tool that allows you to organise and make sense of data in various ways.

  6. #6
    Join Date
    Sep 2012
    Location
    Calgary, AB
    Posts
    1,438
    Rep Power
    46

    Default

    PowerBI is a GUI based report generator. There's been lots of these things over the years. Crystal Reports was the popular one back in the day.

  7. #7
    Join Date
    Mar 2003
    Location
    C-Spot
    My Ride
    11sec S14, Lux Family Bus, VQ35HR
    Posts
    2,575
    Rep Power
    40

    Default

    Quote Originally Posted by JfuckinC View Post
    This quote is hidden because you are ignoring this member. Show Quote
    I feel like you're a drafter no? Its a live materials database from a model that updates in access, i want converted to a structured BOM... i dont even know if its a thing i just think of stuff then find people smarter than me to tell if it's possible lol
    I unfortunately do many many, many things.

    If the materials database is in access you can set up a structured query to fill a BOM form in access. Might just need to create the BOM form itself if the database is live.
    Quote Originally Posted by Yolobimmer View Post
    This quote is hidden because you are ignoring this member. Show Quote
    She wishes it was deep.
    Quote Originally Posted by rage2 View Post
    This quote is hidden because you are ignoring this member. Show Quote
    So deep put her ass to sleep.

  8. #8
    Join Date
    Sep 2008
    Location
    NE
    My Ride
    Ram 1500, '68 Camaro, S14
    Posts
    1,776
    Rep Power
    30

    Default

    I ended up finding a super usefull plugin/app for my program that essentially does exactly what i wanted in a way more simple manner haha...

    Thanks for the input those guys, appreciate it.

  9. #9
    Join Date
    Apr 2006
    Location
    Cowtown
    My Ride
    10' 4Runner SR5
    Posts
    6,010
    Rep Power
    38

    Default

    Tableau or Power BI are great tools for visualizing data in different ways.

    Tableau is fairly intuitive, Power BI I need more time with.
    Ultracrepidarian

  10. #10
    Join Date
    Mar 2005
    Location
    Calgary
    My Ride
    Protege 5 Turbo / Ecoboost FX4
    Posts
    1,249
    Rep Power
    21

    Default

    Isnít there some 6 year old in a third world country who could do this for 8 cents a day?
    ...

  11. #11
    Join Date
    Jul 2004
    Location
    YYC
    Posts
    3,922
    Rep Power
    60

    Default

    Look into KNIME great and free.

  12. #12
    Join Date
    Jan 2019
    Location
    ES Art Room
    My Ride
    #SadLife
    Posts
    3,279
    Rep Power
    100

    Default

    Quote Originally Posted by JfuckinC View Post
    This quote is hidden because you are ignoring this member. Show Quote
    I ended up finding a super usefull plugin/app for my program that essentially does exactly what i wanted in a way more simple manner haha...

    Thanks for the input those guys, appreciate it.
    That's awesome. Apparently, generating MTO's or BOM's is a tricky thing to do. I recall a licensed program called MTO-Gen and know a guy who wrote some sort of Excel code that extracted them and it was expensive.
    Hopefully your method works.

  13. #13
    Join Date
    Sep 2008
    Location
    NE
    My Ride
    Ram 1500, '68 Camaro, S14
    Posts
    1,776
    Rep Power
    30

    Default

    This one essentially runs a live BOM in a palette and you can take “snap shots” and it will compare the difference for you. And you can export to a template which is also super helpful. It also has the ability to isolate items with miss matched descriptions and probably lots of other crap I’ll have to learn haha.

    I too hope it works well! Seems promising.

Similar Threads

  1. Microsoft Excel Training Courses?

    By freshprince1 in forum Computer Help Desk
    Replies: 10
    Latest Threads: 05-11-2013, 06:21 AM
  2. Microsoft Excel help with replacing text

    By yellowsnow in forum Computers, Consoles, and other Electronics
    Replies: 5
    Latest Threads: 12-02-2008, 07:12 PM
  3. Microsoft Excel help

    By Khalil.e in forum Computers, Consoles, and other Electronics
    Replies: 6
    Latest Threads: 01-31-2006, 06:48 PM
  4. Microsoft Excel Question;

    By Wildcat in forum Computers, Consoles, and other Electronics
    Replies: 10
    Latest Threads: 10-15-2003, 11:06 PM
  5. microsoft excel???

    By Import_Girl in forum General
    Replies: 1
    Latest Threads: 03-31-2003, 01:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •