How can i add information from Excel to MS SQL 2000 db?

[passs]

Hello everyone!

Maybe someone know a product or some program which let to add information from Excel file to MS SQL 2000 db table?

Will be very thankfull for any kind of help!

Best regards,
Alexander

 

[pabloj]

Do you mean writing back to the cube?
Or did you post in the wrong forum?

Stick to your guns

 

[passs]

hey Pablo!

I actualy do not understand what does it mean:
"Do you mean writing back to the cube?"

I mean that i have an Excel file, and i want all the data from it write to MS SQL database table.

That's what i mean, and this file is very big, so it is unreal to use copy/past, so i was corius about existing some programm which can help with this work.

Thanks for the answer.
Best reagards,
Alexander

 

[pabloj]

You posted to the wrong forum. There are a VBA, an Excel and a Microsoft Data Transformation Services forums which are more suited

Stick to your guns