April 2, 2008 at 5:47 am
hi.
will u plz tell me how can we export data from excel or other format file into my database .
with export and import .
help me ??/
thaxxx
April 2, 2008 at 6:33 am
For a onetime import you could use the Import and Export Wizard in SSMS; Right click on your database, select Tasks/Import Data. Excel will be one of the options.
If the import is a reoccurring task then an SSIS package or bcp would something you'd want to look at using.
You might get better suggestions if you posted what you're trying to import, providing that doesn't violate your companies policy.
April 2, 2008 at 6:34 am
You should look at Integration Services. This is the primary Extract Transform & Load (ETL) tool for SQL Server. It can open a large variety of data types and move the data into SQL Server databases.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 2, 2008 at 7:44 am
hi ,
Thaxx for reply but i know this how to export and import from dts its easy but i want to this learn with ssis .so will u plz teach me .
Thaxx
April 2, 2008 at 7:49 am
There's no way to teach SSIS within a post on a newsgroup. However, I can point you to a few articles available on the site that should get you started.
http://www.sqlservercentral.com/articles/introductiontodtsinsqlserver2005/1486/
http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/thenewetlparadigm/1719/
Here's a list of articles that have been tagged as SSIS
http://www.sqlservercentral.com/articles/Integration+Services/
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply