ODBC and SQL
-
Hello All, I am sorry for bothering you guys with this but I did perform so "due diligence" to find the answer to this and I am just stuck. Any help thrown my way will be greatly appreciated. I have an ODBC datasource on a PC that connects to a proprietary db. I use Access (link tables) and the datasource to retrieve and examine data. My question is: I have SQL Server 2005 and I would like to know if there is a way that I could somehow use the ODBC connection to connect with SQL Server. I am certain that I could do a lot more with the data linked to SQL as opposed to using Access. I hope I have made my intentions clear and again, thank you (whomever you are) for the assistance. Best regards, F
-
Hello All, I am sorry for bothering you guys with this but I did perform so "due diligence" to find the answer to this and I am just stuck. Any help thrown my way will be greatly appreciated. I have an ODBC datasource on a PC that connects to a proprietary db. I use Access (link tables) and the datasource to retrieve and examine data. My question is: I have SQL Server 2005 and I would like to know if there is a way that I could somehow use the ODBC connection to connect with SQL Server. I am certain that I could do a lot more with the data linked to SQL as opposed to using Access. I hope I have made my intentions clear and again, thank you (whomever you are) for the assistance. Best regards, F