Copying MS Access files to MS Excel


#1

Is there a way to import data off a MS Access file to a MS Excel file? I’m needing to make this a step in my automation process. Thanks!


#2

The most direct method would be to use the database activities to query the data you want from your Access DB and then output it to your target Excel file using a write range activity.


#3

Thanks for the response. This is my first activity in the automation process. I’m self-teaching myself. Can you tell me how to target an Excel file using a write range activity? Thank you.


#4

Can you show me an example of the process flow? Thanks!


#5

Razorback,

Here is a zip containing a simple Access DB and Excel Scope with Write Range. You can change the activities that supply the Datatable to the write range to create a different Excel output.

OutputToExcel.zip (23.2 KB)


#6

Thank you very much.