I've had good luck saving the excell sheet to csv, then using DTS (text) to import. If there are multiple sheets in the original just save them each separately as csv. Email me direct if you have any questions.
-----Original Message----- From: Michael Tangorre [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 1:14 PM To: CF-Talk Subject: CF / Excel / Ranges What would be the easiest way to import an excel sheet into SQL 2K. The excel sheet contains the following: Country name Country abbreviation Country code >From Phone Number To Phone Number Thanks, Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
