MS Access to MS Excel?

Asked By Belle Saint 0 points N/A Posted on - 10/26/2011

I have a database for my project that contains list of this is and dissertations.

I am currently using MS Access for my database and I'm using Visual Basic as my programming language.

Using MS Access, can I transport or transfer my MS Access data to MS Excel?

Is there any other way to do this except from copy and pasting it?

• Status: Open
• Question Views: 930
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Shane F.

Go To Solution

Best Answer

Best Answer

Answered By Shane F. 0 points N/A #96316

MS Access to MS Excel?

Hi Belle,

There's a lot of ways to transfer MS Access data into MS Excel, not just copy pasting. But those ways or methods need a lot of code to be able to use it. I will give you the easiest way to transfer MS Access to Excel.

It will only take you 10 minutes to do it. The first step is open the database that you want to export from MS Access. 

Select the Table > Report > Form or the query that you want to export by the use of the navigation pane. On the ribbon, you will chose external data tab. And in the export section, just click Excel button. 

Provide the export file name and select the excel format that you would like to use in exporting.

Shane

About Shane F.

Questions
0

Answers
4

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 10/26/2011
• Question Category: MS Access

Answered By Clair griffin 10 points N/A #96317

MS Access to MS Excel?

You can try moving the data out of Access by using Access Macro. Access has built-in Macro actions that allow us to do it easily. First, create a new macro and in the first action box select “TransferSpreadsheet”. There are few options in the lower portion of the window available to you. In the “TransferType”, put in Export. If you are using anything from Excel 97 forward, select the most recent option like “Microsoft Excel 8-10” in the “Spreadsheet Type.”

In “Table Name”, put the query you are exporting. Type a path and file name of the file in “File Name”. If you have headings in your table, put yes in “Has Field Names”. 

And put the specific range within the excel sheet you would like to transfer the data to (example: E33:Q79). Then Save the macro with something like “mcr_XLExport” and run it by double clicking on it. 

Check your drive C and you would have got an Excel file with exactly what was in your query.

About Clair griffin

Questions
1

Answers
132

Best Answers
38

• Vote Up 0 Vote Down

• Posted on - 10/26/2011
• Question Category: MS Access