Solved

how to convert multiple excel files with multiple tabs to access,sqllite or any other db that talend knows free

Posted on 2013-06-07
2
515 Views
Last Modified: 2013-11-13
Hi,

I'm doing a dq project with Talend ,client unloaded huge volume of files from sap to excel ,some tables had 80k rows with multiple worksheets,so I have actually 3 questions:
1.how to convert multiple excel files with multiple tabs to access,sqllite or any other db that talend knows?
2.If it's msaccess , how I configure msaccess 2003 db connection in Talend?
Basically I need some open source ,free utility to convert excell to whatever db format, the nbest wouold be sqllite or msaccess but in case of the latest I need to know how to configure it in Talend.
3. May be there's a way to actually use my "Excel Files" with Talend?
0
Comment
Question by:oleggold
2 Comments
 
LVL 21

Author Comment

by:oleggold
Comment Utility
the best option would for Talend to see excel directly but ll the tabs of the workbook, right now I import the workbook but it doesn't see any tables at all
0
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
Comment Utility
It is not a problem to import all excel files in some folder to Access DB if structure of sheets is the same. Can you upload some samples? Remove sensitive data before uploading.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now