chinni1 0 Newbie Poster
SELECT * INTO [supplierexp] FROM [supplier] IN '' [ODBC;Driver={SQLServer};Server=(local);Database=sh op;user name='shop';password='abc123';Trusted_ Connection=yes];"

For above code im getting error like ODBC--connection to '{SQLServer}(local)' failed.Im using the valid username and password only