I tried using the function. But the output was 96 AR 97 IN 98 BR But it should have been 96 AR,MX,BU 97 IN 98 BR Unable to fig why ?? Regards,...
Say there is a table as follows: TABLEMAKE Sourceid destid tableid make 96 96 2 ZB 96 96 2 PN 95 98 3 KL 96 96 2 DR 95 98 3 DW 90 97 2 SE Now I need...
I am reading from and excel file using OLEDB. Due to mixed data types in a column im getting null values inserted into my dataset when i read the...
This is because of the problem of insertion of null values. If we set the registry to support mixed data types and to have maxscanrows as 0.. this...
I have an excel file which has say 5 columns. I know the datatypes of the data in these columns. I then have to get this from the excel in a...
So there will be need to Insert error message into the existing file (i.e add a new col and enter error message).<br />It will be only the 1st req....
I cant add it as a new column in my insert query since the column doesnt exist in the excel...<br /><br />I have to insert data into the existing...
Hi all, Is there any way to insert a new column into an existing excel file.say Example1.xls One way would be to copy the contents of Example1.xls...
So me wont be able to add columns to the excel using file system object. I checked out the net... but found no solution to adding columns to excel...
Do you mean to say something like ExcelObject.columns.add then i cant use it since we dont have the license for it as mentioned earlier. Regards,...
I dint get that. How doi add another column to the excel file usign file system object ? Regards, Resh
My file wil not have the 6th column. i will have to add it at run time just before inserting the error message. adding the column using alter table...
quote:Originally posted by Madhivanan Good to know you completed it To insert data to new column you need to have new column in the EXCEL file and...
One point ...<br />The create query will not work properly and will give error if the input excel file does not have column names and if any data in...
Since column names were not known...<br />i first got the data from the excel sheet 1 into a dataset ( here column names will be in the first row of...
Thanks a lot... i was able to implement my request sucessfully by building the create table query first and then the insert query... Regards, Resh
im really sorry abt this if the prev request is not very possible is there a way to read a specific row from one excel file and insert it directly...
I think im still not being too clear with my request so here its again... I have a request where i have an excel file A.xls which is given as input....
In this case we are coming back to specifying the columns explicity col1,col2,col3... This is all fine if all my excel files will have the same...
Ok ill tell the exact thing i have a input excel file which can have any no. of columns. (Each time a file is given as input it can have varied no....
Separate names with a comma.
