how to migrate ms excel db to mssql server 05 1

[eirikr]

how can i migrate a ms excel db sheet to a table in sql server 2005. Thank you for help.

 

[RiverGuy]

You need to give more information. Do you simply wish to copy the data from an Excel worksheet to a table in a database and then be done with it? Do you wish to copy the data in the excel worksheet and allow users to insert, update and delete information from within SQL Server?

Anyways, the first place to start would be getting the data from Excel to SQL Server. You can do this in Management Studio with the Import/Export data wizard. You can bring up this wizard by right-clicking your database in Management Studio, choosing taks, and then Import Data.

 

[eirikr]

Thanks, it's what i need to know

 

[eirikr]

i get an error message when i try to import an excel databse into a table in sqlserver 2005, the error something about connection to sql failed, no such host is known when i set ms sql native client. Please tell me why, and what should i do. Thanks

 

[eirikr]

I used Import/Export wizards in mssqlserver management studio to migrate data from excel sheet to sql server 05
I followed exactly what were shown in the book:
-data src: ms excel
with excel file path, then next

with dest, i tried either:
-dest: OLEBD for sql, or SQL native client
with my server name

Then i chose copy data from one to more tbls ...

everything seems working, but i failed at validating, error 0xc0047ofe, something with data flow task, the product level is insufficient for component source . What should i do? please help

 

[eirikr]

I got it done, ty for help