# How can I convert Access database to Excel spreadsheet?
**URL:** https://boards.straightdope.com/t/how-can-i-convert-access-database-to-excel-spreadsheet/501807
**Category:** Factual Questions
**Created:** [July 3, 2009, 1:09pm UTC](https://boards.straightdope.com/t/how-can-i-convert-access-database-to-excel-spreadsheet/501807 "2009-07-03T13:09:08Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Snowboarder\_Bo](https://boards.straightdope.com/u/Snowboarder_Bo)
#### Post date: [July 3, 2009, 1:09pm UTC](https://boards.straightdope.com/t/how-can-i-convert-access-database-to-excel-spreadsheet/501807/1 "2009-07-03T13:09:08Z")
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.
---
### Author:  [@K364](https://boards.straightdope.com/u/K364)
#### Post date: [July 3, 2009, 1:38pm UTC](https://boards.straightdope.com/t/how-can-i-convert-access-database-to-excel-spreadsheet/501807/2 "2009-07-03T13:38:40Z")
My version of Excel (2003) opens .mdb files directly - you will get prompted for which table you want in your sheet
---
### Author:  [@Markxxx](https://boards.straightdope.com/u/Markxxx)
#### Post date: [July 3, 2009, 1:48pm UTC](https://boards.straightdope.com/t/how-can-i-convert-access-database-to-excel-spreadsheet/501807/3 "2009-07-03T13:48:57Z")
Just download a trial version of MS Office and open them.
---
### Author:  [@The\_Tao\_s\_Revenge](https://boards.straightdope.com/u/The_Tao_s_Revenge)
#### Post date: [July 3, 2009, 3:03pm UTC](https://boards.straightdope.com/t/how-can-i-convert-access-database-to-excel-spreadsheet/501807/4 "2009-07-03T15:03:06Z")
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.
---
### Author:  [@ouryL](https://boards.straightdope.com/u/ouryL)
#### Post date: [July 3, 2009, 8:36pm UTC](https://boards.straightdope.com/t/how-can-i-convert-access-database-to-excel-spreadsheet/501807/5 "2009-07-03T20:36:19Z")
Export table into Excel?
---
### Author:  [@Tim\_T-Bonham.net](https://boards.straightdope.com/u/Tim_T-Bonham.net)
#### Post date: [July 4, 2009, 3:54am UTC](https://boards.straightdope.com/t/how-can-i-convert-access-database-to-excel-spreadsheet/501807/6 "2009-07-04T03:54:57Z")
OpenOffice is free, and it’s database component Base can read & process most Access files.
Download OpenOffice for this.
---
### Author:  [@Snowboarder\_Bo](https://boards.straightdope.com/u/Snowboarder_Bo)
#### Post date: [July 5, 2009, 10:07am UTC](https://boards.straightdope.com/t/how-can-i-convert-access-database-to-excel-spreadsheet/501807/7 "2009-07-05T10:07:41Z")
thanks every1
got it done
😃
---
### Author:  [@kellylee](https://boards.straightdope.com/u/kellylee)
#### Post date: [April 16, 2013, 9:55am UTC](https://boards.straightdope.com/t/how-can-i-convert-access-database-to-excel-spreadsheet/501807/8 "2013-04-16T09:55:48Z")
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](http://gallery.technet.microsoft.com/Access-To-Excel-Converter-00660936)