PDA

View Full Version : Excel to SQL Connection?


jammer6_9
05-05-2007, 04:57 AM
Is there a way to connect Excel to SQL Server?

My SQL

provider=msdasql.1
source=SalesDatabase
uId=sa
pwd=sa
Bob Phillips
05-05-2007, 09:29 AM
You need to use ADO with a SQL Server OLEDB connection. Do you know ADO?