How Exctract data from MS Access and paste to excel

Hi ,

I need to get data from one of my MS Access data sheet and paste to excel sheet,

can u please give the information to fulfill it…

Tharindu

Accessing data from MS access is as good as connecting to database and querying to it.
Use the query result and move to Excel.

Connect to the access database defining path etc.

and query to access database and get the values in datatable. Further move these datatable values to Excel by using “Write range” activity.
AccessMain.xaml (6.5 KB)

Hope this helps.

1 Like

@anon62075255

Thank u very much for the sharing the details,

I try this way and when I define select statement its not success .

I need to get all data from mdb file.

Tharindu