Save query from external database to table

[corinereyes]

Hi,

Ok here it goes.


I have data coming from an external database. I populate the controls in a form using a query from that external database. We all know that it is read-only as i was only given rights for viewing the the database and extract the data i want.

Now, the problem is, i can not save the data i extracted from the external database and save it another table ( i have to do this because i need to create and relational database from those data i extracted.)

I have used coding to do this,

-an event of passing the value of a control to a variable and make it = to the control (textbox) on another form, an attempt to save the data extracted into another table)

- i have tried using the "query to table" but upon further searching, it is only a snapshot of the data extracted and the "query to table" data will not be updated.

Please , any help will be appreciated on how to do this.

Thanks
Corine

 

[jzwp22]

If you want to save the external data, then you will need to create the table structure necessary to hold that data and then use append queries to copy the data from the external source to you created table structure. All your forms, queries (other then the append queries) and reports should be based on the tables you create.

Of course, you will have to address how you handle the records in your tables as the records in the external source change or as new records are added there.