ETL and Data Integration tools - Modern ETL software for everyone

On version 3.3.75, I have a need to load data from multiple Excel spreadsheets to a single SQL Server Table. Can the tool be enhanced to either load multiple files at once or to load one at a time but be able to define a key and have it update the record if the key is found? Thanks.

Hi.

Many thanks for your suggestion.

1 to load data from multiple Excel spreadsheets

You may use Pro version to do it now

2 to be able to define a key and have it update the record if the key is found
We are planning to add updates into next release. It will take us approximately 3 weeks to do so.

Question: Why do you want to define a key if you may use primary key for it?

DB Software Laboratory

I know it can be done with the Pro version, but it's just too complicated for the level of users that I'm working with. The other version is much simpler.

As far as defining a key, I mean define which field on the source data is the key to match on in the table. I guess really that could be done simply by mapping it, as long as the tool knows what the key is as defined by the database. Really wouldn't matter to me how it worked as long as it was fairly simple and worked. Thanks alot.

As you requested we have added ability to load data from multiple excel files, multiple text files and multiple tables
Please download Vimp 4.4.1.
Documetation is beeing updated at the moment

I downloaded the new version and tried it, but this isn't what I was asking for. I meant I need to be able to load from multiple sources that have different formats. In other words, say my target table has 10 rows. 5 of those are coming from source "A" and the other 5 are coming from source "B". I apologize if I wasn't clear before. Let me know if this isn't clear either. Thanks.

Is it odbc data source or just diffrent folders with files?