This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Im not sure whether it is possible, but I would like to export a file, but write it to an existing database creating a new table. As far as I'm aware the 'In-Database' tools have no option for Microsoft Access Database. I also tried the'Output Data' option but that writes to a new database only?
Any help help on whether it is possible would be great!
Once you've done this, the .accdb format becomes available in the Output Data tool and you can write out to specific tables in your database. I'm attaching a tiny example of using an Analytic App to allow a user to change which table the results get sent to. Let me know if that helps?