Get External Data

[WayneDoherty]

I have my pc setup with ODBC drivers to access a database on the network. In Excel I click on Data, Get External Data, New Database Query. I am then asked to Choose Data Source I scroll down the list to find tman.udd and click OK. A box then comes up saying 'Connecting to Data Source'. I then get a query wizard box asking me to choose the colums.

But I want to use Access. I open Access then I have to open a database so I choose db1. I then click File, Get External Data, Import. The imort box then comes up. I click on File Types and pick ODBC Databases and select OK. Another box comes up asking me to Select Data Source. The only one showing is tman.udd so I click on this and select OK. Then nothing happens, it just goes back to the db1 database. What am I doing wrong.

 

[hneal98]

What are you trying to do? From your explanation, you are not doing something right. There is not Get External Data command in Access.

You can open the Access Database and then select Import and then choose ODBC Databases and go from there.

 

[WayneDoherty]

If you click File, the third one down is Get External Data, then Import, select ODBC but nothing happens.