Export Access to Excel

[melissa]

Can Automation Anywhere export Microsoft Access report data to Microsoft Excel worksheets? If so, are any examples of how to do it available?

[forumsupport]

Definitely yes, Automation Anywhere 3.5 allows you to easily automate, Data Transfer and Data Import/Export.

Automation Anywhere 3.5 provides you with 'Database' command which allows you to connect the database and retrieve a dataset so as to fill the cells of excel file with data fetched from database. You can refer to our online sample task, which does exactly what you want. Here is the link for the same example: http://www.tethyssolutions.com/T19.htm

Also, you can refer to more examples for Data Transfer and Data Import/Export through this link: http://www.tethyssolutions.com/autom...mples.htm#data