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
530 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
[X]
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
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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

627 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