Click to See Complete Forum and Search --> : Excel to SQL Server


tksharma
March 13th, 2001, 10:06 AM
I want to pass values in Excel files to be stored in SQL Server database through a program, is there some tool to do this, I know DTS but it has to be done manually, but can similar function can be done through a program. I understand there is SQL Loader in Oracle which does similar funtion.

Thanks and appreciate your help.