cancel
Showing results for 
Search instead for 
Did you mean: 

MS Access

aseelodeh
Level 5
Hi all, 

Can I find a way to copy data from MS Access without using SQL statement, our Access file is not able to select data from its table. OR if I can export it to excel that will be good

------------------------------
aseel odeh
------------------------------
1 REPLY 1

PabloSarabia
Level 11
Hi @aseelodeh

Is there any business restriction to ​use SQL Statements?

The only solutions I can think of are:

- Create an export task to generate an external Excel file, and execute your queries over this file (This link could helps you https://docs.microsoft.com/en-us/office/vba/api/access.docmd.outputto)
- Create a "view" over the Access, and use the "Transfer" methods to export the info. (For this, here is a link with more info https://stackoverflow.com/questions/20496952/programmatically-export-query-table-from-ms-access-to-excel-using-c-sharp)


See you in the community, bye 🙂

------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
------------------------------