Hi all,
Periodically i need to export a table ('MyTable') from my Oracle 10g database to my Microsoft Access 2007 Database. 'MyTable' table's can change dynamically and the export process have to support it.
For example, initially 'MyTable' table can have a column named 'COL1'. When exporting i need to create the same 'MyTable' table in a Microsoft Access database (this Access database may be a empty access database or if possible i would like to create dinamycally). The next time 'MyTable' can be modified and it can have a new column named 'COL2'. When i export the table 'MyTable' i need to export it with the new structure and content to Microsoft Access Database.
If the structure of original table 'MyTables' was "static" i would make a connection through OLEDB or ODBC (through heterogeneus services configuration) having a predefined Microsoft Access Database, but to being table 'MyTable' dinamic this solution is not valid for me.
Could anyone tell me how could i export the table 'MyTable' to Microsoft Access Database 2007?
Many thanks in advance