![]() I simply want to select it as the target for an export. No, I do not want to replace it, because it is a saved template. If I do, I get a prompt that demands that I replace the database! If I use the Export Dataset feature, and I need to export to the other database (Drawing_PMP_Report.accdb, in this example), I cannot use the Build Button (blue arrow) to select the database: The names are "Drawing_PMP_Report.accdb" and "IRCS_Records.accdb": ![]() These templates also include some saved queries for the user. I had to do this because in some cases TOAD was converting numbers to text data type. If your team is going to look into this for version next, please improve a few issues that are a bit of a pain.ฤก.) I have two "template" Access database files, which have empty tables with the correct table names, column names and data types. That allows me to export to Access just fine, but I simply have not found a way to export from 64-bit TOAD to 32-bit Access. I did not want to "downgrade" my installation of TOAD to 32-bit just to satisfy this weekly requirement, so I created a virtual machine with the same version of TOAD, but with Office 2013, 64-bit. It would really be nice, especially since TOAD can export to 32-bit Excel. If I read this thread correct, it sounds like one should be able to export to 32-bit Access using 64-bit TOAD? I have not been able to do so, including after copying the DAO file you indicated above. I'm also using Office 2013 Professional, 32-bit (Microsoft recommends 32-bit Office for most users). ![]() I also have a frequent (once per week) need to export data from Oracle to two different Access databases, in order to provide the data to other people. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |