I have a server to which I access my data. Let's call it 190.250.65.210.
To get data from this in Access I do this:
1. Click on the "ODBC Database"-import Tab in Access
2. Then choose"SQL Sever" (from the listbox-menu) as Driver
3. And type in the Server: 190.250.65.210
4. I then press next and choose "Change the default database" to "GuitarSales" on the next screen
With this option I can retreive several of my tables.
But I also have a another Table which I at this moment only get to retreive in Excel using a "Office Data Connection" (.odc).
Lets the database I want to retreive: "myrequesteddatabase"
I want to convert this connection type so that I can import it into Access (if this is possible at all).
In Excel, where this connectionstring is currently used, this is the information:
As you can see the two tables have much in common. Is it possible to rewrite this somehow to be importable in Access?
To get data from this in Access I do this:
1. Click on the "ODBC Database"-import Tab in Access
2. Then choose"SQL Sever" (from the listbox-menu) as Driver
3. And type in the Server: 190.250.65.210
4. I then press next and choose "Change the default database" to "GuitarSales" on the next screen
With this option I can retreive several of my tables.
But I also have a another Table which I at this moment only get to retreive in Excel using a "Office Data Connection" (.odc).
Lets the database I want to retreive: "myrequesteddatabase"
I want to convert this connection type so that I can import it into Access (if this is possible at all).
In Excel, where this connectionstring is currently used, this is the information:
Code:
Connectionstring: (only containing information I understand)
Provider=SQLOLEDB.1
DataSource=[B]190.250.65.210
[/B]Initial Catalog=[B]GuitarSales
[/B]
Code:
Commandtext: GuitarSales.dbase.[B]myrequesteddatabase[/B]
As you can see the two tables have much in common. Is it possible to rewrite this somehow to be importable in Access?