I got it
i used the following script
insert into openrowset('microsoft.jet.oledb.4.0','excel 8.0;database=c:\fiches.xls;',
'select * from [sheet1$]')
select * from tablename
hope...
Type: Posts; User: ronaldrahme; Keyword(s):
I got it
i used the following script
insert into openrowset('microsoft.jet.oledb.4.0','excel 8.0;database=c:\fiches.xls;',
'select * from [sheet1$]')
select * from tablename
hope...
yeah sure u can insert a new column in the middle, unfortunately it cannot be done by script, you can do it manually.
after you create the new column, open the design table, your column appears at...
i wanna have a script that imports data from an excel file to my database, how can it be done through a 'script'?
hey dipanjan,
10x 4 ur help...plz, can u give me an example so it would be more clear?
goodmorning,
let us assume i have a table called dbo.Info with some data, for example:
ClientID Name
111 Phil
112 ...
oops its not workin, just another kst> how to use execute immediate? its not working for the above statements
Thnks krishna for your help
i made a stored proceduren i checked the syntax, it was okay:
create procedure sp_priorites
as
execute immediate
alter table dbo.priorites
drop constraint...
Hi all
i have a table called dbo.priorites which contains 2 columns
_codepriorite varchar (20) primary key
_priorite varchar (50) null
so i was asked to change _codepriorite varchar (20)...
hi guys,
i wanna change the type of a column i have in my table;
for example from int(4) to varchar(20).
any script to do that??
thanks in advance
Hi all,
i'm updating a new 'common management' software n i wanna update the database bcoz i added many extra tables.
i did write scripts for all the tables this way:
Create..............