Search results

My SELECT statement is pulling from my external data source. I want the selected records to be imported to my local access MDB into a table I have already set up. How would I let access know which table is local/external in my query?

Import subform filter results to table I have a form with some combo's and subforms that are filtered based on combo selections. I want to import a filtered record set into a table. I have an export button with events. I can't seem to find a method that is suitable for working with this...

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 have a query that connects to oracle. I have a dsn connection profile with a saved password to automate this process as much as possible. I want to have the query automatically select the connection profile, is this possible?

I have a form that has two dropdown lists. First ddl specifies table to work with. Second ddl is populated dependant upon the table that has been selected in the first ddl. I know how to specify form elements inside a query, however this first ddl is selecting the table that I want to pull a...

Running Access 2000. Tried using a link table however it gives me an error saying that I must specify owner because several tables with that name exist. I hit ok and the window closes, I never receive a chance to specify owner (sys?). Is there a way around this or another way to create a...