Importing data from an SQL Server database

[claire_bicknell]

Hi... I know this a really basic question and I am sure someone can solve it in seconds.

I have imported data from an Access database previously by writing this command:

con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Tourist_Advisory_Database_1.accdb; "
        con.Open()

This time I need to import from a SQL Server database what do I need to write instead?

Help much appreciated

 

[MattP]

Forms Over Data Video Series

I would take a look @ #2 specifically though all of the series is good to know.

If you're one of those who insists on doing it the old way then take a look here: ConnectionStrings.com - Forgot that connection string? Get it here!