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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Importing from Excel

Author  Topic 

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2009-06-04 : 05:31:34
What is the best way to import data from excel.?

MCTS certified

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-04 : 05:35:46
1. Any of the ad-hoc functions, such as OPENROWSET.
2. SSIS.
3. Have a makro in Excel exporting to database.


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2009-06-04 : 05:42:57
thank you very much

Rob

MCTS certified
Go to Top of Page

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2009-06-04 : 05:56:21
what about exporting from a pdf?

Rob

MCTS certified
Go to Top of Page
   

- Advertisement -