Wrox Programmer Forums
|
BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9
This is the forum to discuss the Wrox book Professional SQL Server 2005 Integration Services by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy; ISBN: 9780764584350
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 7th, 2007, 03:22 PM
Registered User
 
Join Date: Feb 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Importing a Complex Excel file

I have a xls (4000+ of them actually) that I need to import into sql server. The xls has different formatting in different cells. For example the first two rows may contain name, ssn, etc and rows 5 - unlimited contain semi formatted data. However within that formatted portion of the data I need to iteratively address each row and depending on the data in that row, enter one to many records into a separate sql server table. I have read through Chapter 8 of this book and perused the remaining chapters and am wondering if I can even do this w/o some sort of .Net code (I'm not a programmer). If anyone can provide some direction or hints in the direction I should take or places I should look for an example like this, I would appreciate it

thanks






Similar Threads
Thread Thread Starter Forum Replies Last Post
importing text file into excel stealthdevil Excel VBA 2 July 10th, 2007 11:28 AM
Importing text file into excel anamarijaf Excel VBA 4 January 27th, 2007 05:50 AM
Importing from Excel bmains ADO.NET 1 October 9th, 2004 11:44 AM
Importing a text file to excel using VB ridders Excel VBA 1 April 10th, 2004 03:01 PM
Importing Excel File in DataGrid rylemer Pro VB 6 0 July 14th, 2003 04:37 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.