AutoSave in Access

  • Thread starter Transfer from onyx to access database
  • Start date
T

Transfer from onyx to access database

Not sure if the is the correct term?? What I want to do is to transfer
information from onyx to an existing access data base?
 
B

Barry Gilbert

Access will allow you to setup an ODBC link to tables in other ODBC compliant
databases, which Onyx probably is. In Access, use File, Link Tables. In the
Files of Type dropdown, choose ODBC databses. This will bring up the DSN
dialog and allow you to choose or create a DSN to Onyx. Once this is done,
the Onyx tables will show up as a linked table in the Access environment.

Barry
 
T

Transfer from onyx to access database

Thank you sooo much. So once this is done anytime there is a new entry into
Onyx it will automatically update to the Access Database, correct?
 
K

Klatuu

I am not familiar with onyx, so I can't give you an exact answer; however,
there are some things you might want to check out. If onyx is an
application, hopefully it will have a way to export data in a format Access
can then import. If it can export either a delimited text file or a .csv
file you can use the TranferText method to import the data. If it can output
an .xls file, you can use the TranferSpreadsheet method.

If you can give me some info on what onyx is, perhaps we can find a solution.
 
B

Barry Gilbert

It isn't an update to Access; Access is simply viewing the live table in
Onyx, so updates you make in Access will be stored in the Onyx db.

Barry
 
T

Transfer from onyx to access database

Well, I need the reverse of that then. I need to be able to set up a macro
in Access that will run at the end of the day and pull the information from
Onyx which is Oracle based. So, how do you or can you set the macro up to do
this and does the system have to be on and access open? BTW, thank you so
much for your help.
 
T

Transfer from onyx to access database

Onyx (Oracle), is a database that will transfer via spreadsheet. So, can I
just run a macro that will export the data from onyx to access using the
TransferText method?
 
B

Barry Gilbert

It looks like we're working on two different possible solutions. The
TransferSpreadsheet will work, too. The difference is that, with
TransferSpreadsheet, you're making a copy of the data and copying it into
Access. With the ODBC link, you have a link to the actual data, not a copy. I
guess it depends on what you want.

Barry
 
T

Transfer from onyx to access database

Both actually, either of these will work. What my end result is that I can
upload any new data from onyx, and I want it to update my Access database at
the end of the day "via" automatic. So I don't have to manually do this
everyday, I want to be able to have something in the background that will run
at the end of the day and I don't have to do it. Does this make sense?
 
Top