Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X.

learn more… | top users | synonyms

1
vote
3answers
2k views

Create/Delete file using SQL Server 2008

I have an Excel file in C:\testing.xlsx. I am exporting data from my database table to Excel using [OPENROWSET (Transact-SQL)]1 method. Now I want to clear or delete all rows in my Excel file by ...
1
vote
2answers
4k views

Exporting data to excel

I want to execute some stored procedure and I want to export that result to Excel. How can Do that ? I'm new to SQL. any help or tutorials about this will appreciated.
1
vote
1answer
2k views

OPENROWSET can't import an excel spreadsheet into SQL Server 2005 Express

I am trying to run the following query to select data from an excel spreadsheet: SELECT FT_ID_SOCIETE_FF2C,FT_NOM,FT_ADR1,FT_ADR2,FT_ADR3,FT_CP,FT_VILLE,FT_TEL,FT_FAX,F10 FROM OPENROWSET ...
2
votes
3answers
642 views

EXCEL sheets batch input to Access

I have a lot of Excel datasheet (in one file) I want to batch input to Access but I can't find a sample code to do it the name of datasheet in access is same as in excel is there any code of ...
6
votes
1answer
909 views

Can someone explain the magic of Opendatasource/Openrowset?

When pulling information from an excel file (or ms-access DB) I commonly use something like this: SELECT * FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0', 'Data Source=C:\test.xls;Extended ...