Software

Ask something
Discussion Locked

How do I ???? part deux

0 helpful
10 replies

by joeplaisted

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Okay,
Because of the very talented people, (and the amount of points I give, but mainly the talented people)I get the answers I need, but this one s driving me crazy. My database is up and running and accepting info from the Project Managers, but the lead PM wants to have his reports outputed into an Excel spreadsheet. The form is simple enough with columns for PM name, Project name, columns for the Follow up dates, then a column for the Start Date of the project, and the Completion date of the Project. My question is how do I get the information from the Access database into the Excel Spreadsheet?

10 replies

by dklippert

If your data is contained in a table, you can export to Excel in a couple of ways.
Select the table. Go to Tools>Export and choose Excel as a file type.

Select the table. Go to Tools>Office Links. Choose Analyze with Excel.

Select the table. Go to Edit>Copy. Open Excel and Paste.

You can also create a macro to do the job. Go to Macros.
Click on New or Design.
The Action is TransferSpreadheet. Fill in the Action arguments at the bottom of the form. Save the Macro. You could then attacjh it to a button so the PM would only have to click to send the data to Excel.

by oz_media

I think you can just export with the macro command into Excell. It's been a while since I used Access but if I remember correctly you just do an OutputTo and then convert the macro to VB so you can read the information. Then you will have the header and row information for Importing to Excell.

Like I said, I'm really rusty on access but this should get you on your way to success with Access!

by julioairizar

Is simple to do, here is how:
1.- Create a new macro.
In the Macro window, under Action column, select the command: "OutputTo". In "Object type" select: Report; in Object Name, of course, the name of the Report you want in Excel. In Output format, select Excel. In Output file, write thr path to the folder, where you want to save Excel book from Report.

by julioairizar

Is simple to do, here is how: (part I)
1.- Create a new macro.
In the Macro window, under Action column, select the command: "OutputTo". In "Object type" select: Report; in Object Name, of course, the name of the Report you want in Excel. In Output format, select Excel. In Output file, write thr path to the folder, where you want to save Excel book from Report.

by julioairizar

If you set: Auto Start to Yes, Excel will open the file in the moment you run the macro.
Part II:
In the form create a button and in OnClick event asign the macro you just created. Tip: If you want you can asign more actions to this button, for example, maybe you don't only want to send the Report to Excel, so to be printed too. So open the Macro and after the action "OutputTo", select OpenReport, put the Report name and in a View Option, select "Print" or "Print preview". That's all. After all this was created you can convert the macro to Visual basic so the action button run faster. With the form open in Design view, go to Tools, Macro and click in Convert Form's Macros to Visual Basic. Hope this help.

This discussion is closed to new replies.