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)
 Inserting Data from excel

Author  Topic 

jgallen23
Starting Member

17 Posts

Posted - 2007-01-23 : 13:39:05
I have an excel document with page names that I need to import into sql in the Pages table, page column. I'm not sure how to write an insert statement to add all items at once.

here are a few of the pages that I need to import:

Home Page
Article - How to…
My Friends (1st Person)
Remove Friend
Friend Requests
My Requests
Settings
Invite a Friend
Ignore List
Invite Sent Confirmation
Inbox
View Message

anybody know the easiest way to do this?

sshelper
Posting Yak Master

216 Posts

Posted - 2007-01-23 : 14:11:42
Try checking out the following link and see if it helps you in importing an Excel file into your table without the use of DTS/SSIS:

http://www.sql-server-helper.com/tips/read-import-excel-file-p03.aspx

SQL Server Helper
http://www.sql-server-helper.com
Go to Top of Page
   

- Advertisement -