Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kote_alex
Posting Yak Master
112 Posts |
 Posted - 2009-04-06 : 03:37:53
|
| does anyone know how to transport data from xls file to sql 2005 ? 10x ! |
|
|
EugeneLim11
Posting Yak Master
167 Posts |
Posted - 2009-04-06 : 04:02:19
|
| yes. Go to SQL 2005 server Manager studio, Right click on database, Tasks > import data.In the pop out select from Excel.. the rest is pretty simple :)regards,Eugenecheck out my blog at http://www.aquariumlore.blogspot.com |
 |
|
|
kote_alex
Posting Yak Master
112 Posts |
Posted - 2009-04-06 : 04:17:28
|
quote:
Originally posted by EugeneLim11
yes. Go to SQL 2005 server Manager studio, Right click on database, Tasks > import data.In the pop out select from Excel.. the rest is pretty simple :)regards,Eugenecheck out my blog at http://www.aquariumlore.blogspot.com
10x ! I got it ! :)and another question ... why can't I migrate a ssis package from sis server to file? I think I'm doing the right steps.. Mangement - Legacy - Data Transformation Plan ... migrate package ... right ?and after that it gives me a error like ... Invalid instance (invalid column name) |
|
|
|
|
|
|
xls to dbf conversion