Read information from excel file into ms sql table ?

Hi,

I want to insert a long list of articles and prices from a excel ark to two different database tables. These tables are linked together with a unique id, called obj_num.

Is there any possible way to do this ? Right now I do i manually and it takes for ever!

My Excel ark,
Column A1 (Article)
----
Coke
Fanta
Sprite
etc ..

Column A2 (Price)
----
2
2.2
3
etc ..

My database
table_article
------
obj_num
name

table_price
------
obj_num
price

Best Regards
Magnus

Quote:

Originally Posted by mberggren

Hi,

I want to insert a long list of articles and prices from a excel ark to two different database tables. These tables are linked together with a unique id, called obj_num.

Is there any possible way to do this ? Right now I do i manually and it takes for ever!

My Excel ark,
Column A1 (Article)
----
Coke
Fanta
Sprite
etc ..

Column A2 (Price)
----
2
2.2
3
etc ..

My database
table_article
------
obj_num
name

table_price
------
obj_num
price

Best Regards
Magnus

if this is one time, i'd rather use a DTS (Enterprise Manager - Import Data). then do everything using query