Importere data

Du importerer til en temporær tabel, herefter kører du en opdateringsforespørgsel og indsætter dine beregninger heri.

You should be able to link your Oracle tables into Access using an ODBC connection (DSN) if you have the ODBC drivers installed. Then you can manipulate the data using either queries or code.

If you work with Oracle databases then it is very likley that you already have the necessary drivers installed.

You can try this.

From the menu choose File+Get External Data+Link Tables. Now choose ODBC Databases from the  File Types list. (last one in list)
Now press the Machine Data Sources Tab and then New.
Press Next (User Data Source is Default) and Next and then Finish.

From here you should get a window up wher you have to enter Server and Database information. If youdont get this then you should try getting hold of the ODBC drivers.





Then Choose Microsoft ODBC for Oracle.

"Then Choose Microsoft ODBC for Oracle."

should have been at another palce, but I'm sure you get the idea.

status?

damon>Its easier for use to help with a bit of feedback.

status?

damon you have a much better chance of getting help if you give some feedback, and maybe also close some of the 21 open questions you have.