Can I import Access d/b into Excel ?

C

chris

I have Windows ME running Office 2000. Can anyone suggest to a newbie how to
get my Acess databases into Excel.
The help file says to use "Get External Data" but when it comes to 'Browse'
it does not display the Access files I want to import.
Cheers Chris
 
J

John Ski

I have Windows ME running Office 2000. Can anyone suggest to a newbie how to
get my Acess databases into Excel.
The help file says to use "Get External Data" but when it comes to 'Browse'
it does not display the Access files I want to import.
Cheers Chris
You can open an Access DB in an Excel sheet from File>Open, Scroll down to the
file type. I'm not sure exactly what you want to do, but you could then use it
as is or Cut and Paste into another sheet, if that would help.
"Any sufficiently advanced technology is indistinguishable from magic"
***Arthur C. Clarke***
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top