Can download data from Oracle using an Openquery which creates the table once called. Is it possible to create the table beforehand and have the oracle data insert into a table that has already been created?
If I can create the table then the datatypes will be properly specified. Otherwise, the initial load may have to be downloaded into a temporary table and then reloaded into the "permanent" table. Would like to save a step if possible. Please be specific with the syntax as several variations of the select/insert using openquery have been attempted.