Post reply

automated excel load

  • April 15, 2008 at 8:50 am

    #189150

    hi,

    I have been unable to create an automated data load using excel. i have done it using flat file. but when using excell it cant read multiple files(gives an error).

    can you guys give me some instruction of what to do..

    thanks

  • April 15, 2008 at 9:33 am

    #802655

    This will give you exactly what you need, loading data from multiple excel files was a big pain, it took me a while to figure this out.

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2317252&SiteID=1

  • April 15, 2008 at 2:55 pm

    #802809

    May I know how many files you are talking about. Reason is, if it is just a few let say 5, I will suggest you to drag and drop 5 Excel source, but otherwise if it is many( a lot ), you would end up using a loop, again, it depends.

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply