Thread: import dat from Excel to sql database 2005
View Single Post
  #4 (permalink)  
Old 04-17-2008, 06:17 PM
justto_doit justto_doit is offline
Newbie
  
Join Date: Apr 2008
Posts: 6
Rep Power: 0
justto_doit is on a distinguished road
Default Re: import dat from Excel to sql database 2005
Without excel reference, you can just use database connection to connection to the excel just look the excel as a database.
Read the data out
Process what you need
Insert into the SQL server

Or you may just use the SQL server management studio to import the excel if this is only a one time job.
Reply With Quote