How is the adress stored in the db?

There's a simple reason you don't get much help around here. TRY FOR YOURSELF first, then if all fails come back here. Check the access help for that...

Did you actually try this???

Insert into tableName (col1, col2, col3) Select col1, col2, col3 from OtherTable. Looks like you can do something like that using the code you just presented.

You can also check out difference.

You can't sue select into to get the data back, but you can do insert into select

I confirm that it runs in another process (checked using a waitfor delay in a job that I fired from an alert).

You can always execute the job right away. But I'm not sure that this is called as an external process... but that would be pretty easy for you to...

Can't you just link the tables?

Can't you also just copy that code on that db on do the reverse process... or code and insert into select...

This is what you need :

Select * from INFORMATION_SCHEMA.VIEW_COLUMN_USAGE where View_Name = 'vwFormsUsage'

And if it wasn't for the dynamic sql part, we'd all had been done 8 posts ago. Seriously, why do you HAVE TO use dynamic sql??????

Ya, that would work. But for the love of G*d, split this into 3 procs and let the app decide, AS IT MUST ANYWAYS.

Actually it'll be select * from dbo.MyFunction (@Param1,...) if you need to select from it.

I think you can run that into batch when using bulk insert but I can't help you much more than that, sorry.

In a stored proc.

Or in am inline table function if you need to use that in an inner join.