aeshepherd
asked on
How do I reference individual Excel cells using VBScript when using DTS with Excel source and SQLServer destination
I have been given the task of creating a DTS package (SQLServer 2000) which has as a source an Excel workbook with several worksheets, and SQLServer tables as a destination. The Excel worksheet is not straightforward in that a certain column or columns contain different types of data, depending upon the row. The worksheet has been created to look like a form that a user can fill out, which is why different rows contain different types of data in a particular column. There are checkboxes in some cells, text in others, and dates in others. A straightforward column mapping obviously will not work, and cells need to be referenced differently. Would you please help me out with this and let me know if this is possible and the best way to go about this? I am new to DTS and am trying to read and research as much as possible to figure out the best way to handle this project.
Thank you for your help.
Anne
Thank you for your help.
Anne
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry, posted to wrong question...
ASKER
Thank you very much for you help.
Anne
Anne
I am using late bindingg and can send the full method when I return to work next Tuesday.