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 ««12

getting null values while imporing from excel Expand / Collapse
Author
Message
Posted Tuesday, July 8, 2014 2:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 10:26 PM
Points: 8, Visits: 116
actually one procedure is there for validating(checking for sheet names and for columns in sheet) excel and import data by using OPENROWSET('Microsoft.Ace.OLEDB.12.0').
and it split the data into multiple tables.

this procedure is invoked by .net application, in application i got this error message.
and now i tried from sql server management studio, it runs properly
but from application it throughs error messge...
Post #1590233
Posted Tuesday, July 8, 2014 2:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 10:26 PM
Points: 8, Visits: 116
one procedure is there for validating ,dumping and to split the data into multiple tables using OPENROWSET('Microsoft.Ace.OLEDB.12.0').

here validating means checks for sheet names, columns in sheet or correct or not.

when this procedure invoked from .net application it gives error

now i tried from sql server management studio it works properly, but from application it gives error.
Post #1590235
Posted Tuesday, July 8, 2014 2:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 10:26 PM
Points: 8, Visits: 116
one procedure is there for validating ,dumping and to split the data into multiple tables using OPENROWSET('Microsoft.Ace.OLEDB.12.0').

here validating means checks for sheet names, columns in sheet or correct or not.

when this procedure invoked from .net application it gives error

now i tried from sql server management studio it works properly, but from application it gives error.
Post #1590236
Posted Tuesday, July 8, 2014 2:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 10:26 PM
Points: 8, Visits: 116
one procedure is there for validating ,dumping and to split the data into multiple tables using OPENROWSET('Microsoft.Ace.OLEDB.12.0').

here validating means checks for sheet names, columns in sheet or correct or not.

when this procedure invoked from .net application it gives error

now i tried from sql server management studio it works properly, but from application it gives error.
Post #1590237
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse