Can I import a GP Report into Access?

Tags:
Microsoft Access
Microsoft Excel
Microsoft Great Plains
I work for a company that doesn't have an IT background. They seem to live in Excel, FilePro, and they recently installed GP 2016, but they do not understand how to use it fully. I noticed that I can do a query and print out all my purchase orders from GP and save them to an excel file. I'm trying to teach myself how to do access and my goal is trying to make my job easier as they do a LOT of redundancies that make a task that is 10 mins typically .. into a task that can take 4 hours. Anyway, I'm trying to figure out how I can make something that I can input the data from the report into an access database and let me capture the data info fields for other reporting issues. It's hard to explain but the jist of it is.. I have to enter orders into GP which make a purchase order.. then I have to hand type all those 100's of orders onto excel pages for each purchase order and save them each individually.. to their own file named after each PO# .. and then I have to dig around for Art files.. and it takes hours to do stuff that should take no time at all.. My goal is to centralize it more in Access so I can import the purchase orders from GP.. it auto populate the excel and do stuff a bit more automatically..


Software/Hardware used:
Microsoft Great Plans, Microsoft Access 2016, Excel 2016
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: