Import data directly from excel into SQL Server
SELECT * INTO Importxl from
OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=F:\\Book1.xls', 'SELECT * FROM [sheet1$]')
Set the configuration surface area by Launching Surface Area Configuration
SQL Server Surface Area Configuration is available on the SQL Server Start menu:
On the Start menu, point to All Programs, Microsoft SQL Server 2005, Configuration Tools, and then click SQL Server Surface Area Configuration.
The first page to appear is the SQL Server Surface Area Configuration start page. On the start page, specify which server you want to configure:
1. Click the change computer link adjacent to Configure Surface Area for. The default value is localhost. If you previously selected a named server, you would see the server name.
2. In the Select Computer dialog box, do one of the following:
To configure SQL Server 2005 on the local computer, click Local computer.
To configure SQL Server 2005 on another computer, click Remote computer, and then enter the computer name in the text box.
To configure a failover cluster, click Remote computer, and then enter the failover cluster instance name in the text box.
3. Click OK.
|
No responses found. Be the first to respond and make money from revenue sharing program.
|