Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
525 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
ID: 39230976
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 40

Accepted Solution

by:
als315 earned 500 total points
ID: 39231241
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
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 use a scrolling table in Microsoft Excel using the INDEX function.

860 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