Access / Excel question | Off Topic | unofficial empeg BBS

Quick Links: Empeg FAQ | RioCar.Org | Hijack | BigDisk Builder | jEmplode | emphatic
Repairs: Repairs

You are not logged in. [Log In] empegbbs.com » Forums » General Discussion » Off Topic » Access / Excel question

Topic Options

#329923 - 09/02/2010 01:25 Access / Excel question
msaeger carpal tunnel Registered: 23/09/2000 Posts: 3608 Loc: Minnetonka, MN	I have a low level of Excel knowledge and even less about Access so I figured I would ask and see if anyone can help me with this. I have an Access database which contains part prices. I have an Excel spreadsheet which I need to record which parts I use along with other info including prices. Can I somehow get Excel to query the Access database and get the prices ? _________________________ Matt
Top

#329924 - 09/02/2010 02:49 Re: Access / Excel question [Re: msaeger]
larry818 old hand Registered: 01/10/2002 Posts: 1033 Loc: Fullerton, Calif.	Access can save it's data in Excel format...
Top

#329929 - 09/02/2010 12:08 Re: Access / Excel question [Re: msaeger]
maczrool pooh-bah Registered: 13/01/2002 Posts: 1649 Loc: Louisiana, USA	You should be able to query an Access database in Excel by clicking data on the Excel menu at the very top and then Import External Data, New Database Query, and MS Access Database under the Databases tab. Keep in mind this varies somewhat with office version. Hope this helps, Stu _________________________ If you want it to break, buy Sony!
Top

View All Topics