I have more than 4000 access(.accdb) files on my server. i have to export each file to separate CSV file. Is there anyway to export into CSV without manual effort(doing one by one)
I have more than 4000 access(.accdb) files on my server. i have to export each file to separate CSV file. Is there anyway to export into CSV without manual effort(doing one by one)
I'm sure you can loop through the directory and access the files but you dont give enough info to be more specific.
Are all the Accdbs the same? What do you need to export?
edit: cross posted https://access-programmers.co.uk/for...=1#post1642237