Hi Friends,
I m already created a table and i wanna to insert values in that more than five hundred row ,that values are stored in Excel files,Here i ve the doubt is it possible to insert values from excel sheet?
i ve current data base of ms sql 2000 ,if it is possible means tell me how to insert values using query?
ex:
---
create table test
(
item_code int,
item_name varchar(50),
bill_qty float,
bil_date datetime
)
in that excel file also had the same column name names
Thanks
Rocky