Wondering how I can do a SELECT INTO into my access database from oracle. Import table wizard doesn't work because I am selecting from dba_tab_columns and it tells me to qualify the table name but I never receive a chance to qualify it as I am only given the option to select it from a list.
I had a form running a SQL passthrough query I wrote for the select into a subform. However when you first load the form you have to select the Data Source profile about four times before it will work and sometimes disconnects while the form is loaded, losing all of my subform contents.
So I started working on this new SQL-passthrough. I understand that it runs the commands directly through oracle, so how can I store the dataset into some kind of buffer and then create an Access table using this dataset?
I had a form running a SQL passthrough query I wrote for the select into a subform. However when you first load the form you have to select the Data Source profile about four times before it will work and sometimes disconnects while the form is loaded, losing all of my subform contents.
So I started working on this new SQL-passthrough. I understand that it runs the commands directly through oracle, so how can I store the dataset into some kind of buffer and then create an Access table using this dataset?
