Forum Discussion
Error 3048 when exporting
Hello, I am attempting to export a database to an excel file. Access creates an empty file, and throws the error "Cannot open any more databases", which from what i've seen so far, is error 3048...
Hi,
The sources of these SELECTs are queries, they may open several tables.
I would do successive Exports of each request rather than these UNION consumers.
In automation use CopyFromRecordset of Excel library.
https://learn.microsoft.com/fr-fr/office/vba/api/excel.range.copyfromrecordset
The sources of these SELECTs are queries, they may open several tables.
I would do successive Exports of each request rather than these UNION consumers.
In automation use CopyFromRecordset of Excel library.
https://learn.microsoft.com/fr-fr/office/vba/api/excel.range.copyfromrecordset