please check it - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

please check it

Author

Topic

ramu143
Yak Posting Veteran

64 Posts

Posted - 2008-06-24 : 06:24:51

insert into OPENROWSET('Excel 8.0;Database=D:\testing.xls;',
'SELECT * FROM [testing$]')

getting errore

Incorrect syntax near ')'.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-06-24 : 06:35:35

Not sure what you are trying to do. Are you trying to insert into Excel from SQL Server or are you trying to insert into Excel from Excel?

To insert into SQL Server, try the following:


select *
into <Tablename>
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
  'Data Source="D:\testing.xls";Extended properties=Excel 8.0')...[testing$] a

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-06-24 : 07:04:27

insert into OPENROWSET('Excel 8.0;Database=D:\testing.xls;',
'SELECT * FROM [testing$]')
select * from yourdatasourcewhichcouldbeatableorvieworfunction

E 12°55'05.25"
N 56°04'39.16"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources