hi Jim
I am sure i am using excel file only i have to import data from excel file.....please suggest me one solution as soon as possible....... ......
priyan
Last Activity: Nov 21 '07, 05:23 AM
Joined: Aug 2 '07
Location:
-
hi Jim thanks for u suggestion but i am getting an error when i used the syntax as if u r given
when i used ur first command
Code:INSERT INTO dbo.MyTable SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Documents and Settings\MyName\Desktop\myspreadsheet.xls', [Sheet1$])
my error is
[code=text]
Msg 15281, Level 16, State 1, Line 1...Leave a comment:
-
how to import a data to table from file and export data from table to file
hi all,
I am newbie to sql server 2005. I want to import a bulk data from an excel file to the table.......... pls suggest me a solution on how to do this........... .....pls reply me as soon as possible....... ....
thanks in advance,
priyan. -
doubt in CASE command
Hi all,
I am having a table and there is a column named id. I have to choose the id and in case if id is null i have set id to '1' otherwise the same id should be displayed. For this i tried the following query but the result is not the proper one which i expect pls help me in this regard
[code=sql]
select substring(numbe r,2), case when substring(numbe r,2) is null then '1' else substring(numbe r,2) end as id from emp... -
Please help me to solve this problem function is running properly and also insertion is taking place but updation alone is not working. Table is not get updated i don't no why it is like this........... ..please help me to solve this problem........ ...As soon as possible....... ..........Leave a comment:
-
doubt in update query inside a function
hi all,
I wrote a function in postgre to insert or update a row in to a table. In my function insert query is working fine but updation is not working please help me....
here is my function
[code=sql]
CREATE OR REPLACE FUNCTION savequestionban k_quest(pquesti onid integer, pquestionbankid integer, pquestion text, pquestionsno integer, pquestionhistor y text, pquestionparame ter text, pquestionsource... -
doubt in exporting a file into database
Hi all,
I want to import data from an xml file into postgresql database. Can I do that? Please help me how to do that? -
datamodel
hi all,
anybody knows how to get datamodel for a database in postgresql.....
please help me immediately.... .
Thanks in advance.....
priyan..... -
Hi rski,
Thank u very much for helping me
PriyanLeave a comment:
-
Thank u rski i got the answer thank u verymuch....but if u explain me why we are using such an expression it would be very useful for me and i would be verymuch greatful to u.....
Thanks
priyan...Leave a comment:
-
thank u rski for helping me but i am having another doubt can i retrieve rows from the same table where the code has two dots...ie.,
[code=text]
001.01.01
002.01.02
[/code]
Please help me...Leave a comment:
-
problem in using unicode datatype
Hi all,
I am having a table in which a column should have unicode text....... i dono what datatype to use....so please help me to do so..
Thanks in advance
priyan -
Problem regarding a function
Hi all,
I am having a table, in that a column called code contains a character varying datatype and has subject code in it.....
subject code will be in the form
[code=text]
001
001.01
001.02
02345.01
002.01
001.01.01
001.01.02
[/code]
here i want to retrieve only the rows having code with one '.' dot ie., i have to retreive rows having code... -
hi all,
Please reply me soon..........
I have installed oracle 10g in my system.Now i want to install forms and reports of version 9i. Can i install it in the same system or not.Please help me as soon as possible. please....
Thanks
priyan....Leave a comment:
-
doubt about installation of forms and reports
hi all,
I have installed oracle 10g in my system.Now i want to install forms and reports of version 9i. Can i install it in the same system or not.Please help me as soon as possible. please....
Thanks
priyan. -
Hi
Thank u very much......It is now working correctly...... Once again thanks a lot for patiently answering all my questions and clearing my doubts.........Leave a comment:
-
no now also same error..........Leave a comment:
-
I deleted all the rule and created a new one and when execute insert statement it is showing me the same error.........Leave a comment:
-
no i din't delete it I have to delete it means how to delete it?...Leave a comment:
-
hi
I tried ur query it is executed sucessfully and now i tried to insert into the view empp but I got the following error.
[code=sql]
CREATE RULE emp2_ins AS ON INSERT TO empp
DO INSTEAD
INSERT INTO employee VALUES (NEW.name,now() ,NEW.id);
insert into empp values('shylaja ',now(),5);
[/code]
[code=text]
ERROR: infinite recursion detected...Leave a comment:
No activity results to display
Leave a comment: