Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Insert Local Excel data sheet into SQL(remote) Server Expand / Collapse
Author
Message
Posted Wednesday, March 10, 2010 11:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 5:35 AM
Points: 5, Visits: 224
insert INTO tbL_excel
SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=\\pc31\C\Testexcel.xls',
'SELECT * FROM [Sheet1$]')


anybody help me solve this.

Local Excel sheet to SQL(Remote) Server

Rajesh
Post #880728
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse