SELECT * INTO XLImport1 FROM EXCELLINK...[Customers$]


SELECT * INTO XLImport2 FROM OPENQUERY(EXCELLINK,
    'SELECT * FROM [Customers$]')
			

SELECT * INTO XLImport3 FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\test\xltest.xls;Extended Properties=Excel 8.0')...[Customers$]

SELECT * INTO XLImport4 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\test\xltest.xls', [Customers$])

SELECT * INTO XLImport5 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\test\xltest.xls', 'SELECT * FROM [Customers$]')

quote:

---

Originally posted by santana

Hi,

I tried those, but I received error:

- SELECT * INTO [finance].[dbo].[fin_history] FROM 'C:\Historical.xlsx'['2007-2009 Total']
error: Incorrect syntax near 'C:\Historical.xlsx'.

-SELECT * INTO [finance].[dbo].[fin_history] FROM OPENQUERY('C:\Historical.xlsx',
'SELECT * FROM [2007-2009 Total$]')
error: Incorrect syntax near 'C:\Historical.xlsx'.

What is [Customers$] in your example?

My excel file is in the same server to the sql server. But I didnt have Excel tool in the same server, only in
another one.

Could you help me again, please?

path/file - C:\Historical.xlsx
only one sheet - ['2007-2009 Total']
table - [finance].[dbo].[fin_history]

Thank you!

Regards,

---

quote:

---

Originally posted by behrman

Hi.

SQL Server 2005 Management Studio provides the ability to copy and paste columns directly from Excel to SQL Server when the table and column names match up. Let's walk through a simple example. Assume you have a database called 'Test' with a table called 'MyTable' consisting of two columns (MyID, MyDesc). In addition, you have an Excel worksheet where you want to load data directly from Excel to SQL Server. Let's walk through setting up and testing that scenario.
For detailed operations, please refer to http://www.mssqltips.com/tip.asp?tip=1430.

Regards,
behrman.

RAQ Report: Web-based Excel-like Java reporting tool

---