External Data

[fabiobarreto10]

friends,



I have a database where I import data from another database as follows:

Care tables that seat on the "External Data". Once you have a code for the event by clicking a button on a form, that takes each
record and puts in another table. At the end of the code imported table is deleted. Works perfectly, but I wonder if one way to accomplish this automatically.

For example, a button, which, via macro or vba, I say import external data, run a query to include external data in this table to an existing table in the database table and then delete this "temporary" my BD?

Thank you.

[June7]

Don't understand your question. You say you already have working code? That code is triggered by a button click? So what do you mean by 'automatically'?

[fabiobarreto10]

I managed to solve. Thanks for helping.