How can I convert Access database to Excel spreadsheet?

Factual Questions
1

I have some old Microsoft Access .mdb files that I need to take a look at, but I no longer have a copy of Access.

Is there some way to convert these files to Excel spreadsheet (or worksheet)?

I know that if I had Access I could export them to Excel files, but as I said, I no longer have a copy of Access.

Thanks for any help.

2

My version of Excel (2003) opens .mdb files directly - you will get prompted for which table you want in your sheet

3

Just download a trial version of MS Office and open them.

4

Also if free trials, and opening up directly in excel isn’t enough I can answer the op directly

Open a excel spreadsheet and go to the data tab.

Click get external data, then pick access and browse and open your database file.

Almost there! Pick table and hit okay. Your data should be open now.

Now to finish converting it to a spread sheet hit ctrl+a to select all then click the design tab.
Click convert to range and save the spread sheet.

If you want it to look lke a normal spread sheet you can edit the text colors in the home tab.

5

Export table into Excel?

6

OpenOffice is free, and it’s database component Base can read & process most Access files.

Download OpenOffice for this.

7

thanks every1

got it done

:smiley:

8

Yeh Snowboarder Bo
Firstly you have to recover the access file and then you can easily convert access database to excel sheet. By Reading the article you can easily get the appropriate solution the link is: http://gallery.technet.microsoft.com/Access-To-Excel-Converter-00660936