import xls --> mssql
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16427
Printed Date: 29 March 2026 at 9:52am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: import xls --> mssql
Posted By: snooper
Subject: import xls --> mssql
Date Posted: 04 September 2005 at 8:05am
|
hi all
i have a table in a MSSQL DB, that i would like to import data from an excel doc. there is an indetity column, which i hope will incerment properly. how can i do this? thanks! |
Replies:
Posted By: bootcom
Date Posted: 04 September 2005 at 8:20pm
|
Well if you have MS Access its real simple. Import the data into Access and then provided you have your DSN set up, use Access to export the data to your SQL server database.
 |
Posted By: snooper
Date Posted: 05 September 2005 at 5:19am
| thanks, but i dont have DSN - SQL is on a remote server. |
Posted By: snooper
Date Posted: 05 September 2005 at 5:32am
|
update: i managed to do this thru the DTS import/export wizard.
thanks again
|