Access 2007 oracle odbc driver

Open your Microsoft Access database. Select the External Data tab in the ribbon. Expand the New Data Source drop-down and select From Other Sources, then select ODBC Dababase. In the Get External Data - ODBC Database dialog box, select Import the source data into a new table in the curent database.  · The main thing is that you need to install the Oracle driver -- (not the Microsoft to Oracle) driver. You have to go to the Oracle site and download the driver and install it. This will place an Oracle app on your workstation which you open and have tab dialog windows where you configure your ODBC connection. Then you use that as your dsn to connect to the Oracle DB .  · On , th*****@www.doorway.ru wrote: Did you check with www.doorway.ru?-Tom. Does anyone knows the odbc driver / string to .

Go into the ODBC Administrator and create a new DSN using the System DSN tab of the administrator tool, and specify the Access driver instead of the Access driver. You'll probably want to name it differently - perhaps something like "PBRIS". This ODBC Driver, Microsoft Access accdb ODBC Driver, can be downloaded here. Connection Strings. The Microsoft Access accdb ODBC Driver driver can be used to connect to the following data sources by using the following connection string references: Access Access 97 Access Access Access Access Access Access The main thing is that you need to install the Oracle driver -- (not the Microsoft to Oracle) driver. You have to go to the Oracle site and download the driver and install it. This will place an Oracle app on your workstation which you open and have tab dialog windows where you configure your ODBC connection. Then you use that as your dsn to connect to the Oracle DB from an Access DB.

I have a windows 7 64 bit desktop with some 32 bit applications that need to connect to an oracle database. Open Control Panel > Administrative Tools > Right Click Data Source (ODBC) > Properties > Change the Target and Start In to %windir%\syswow64\. I have verified the ODBC connection is. Access to develop on another machine and using Access 32 bit Runtime for the clients.