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.
|