I need to implement to load one Excel file into AWS RDS Database. And Excel file have multiple sheets and one sheet have 65000 records. And I don't know how many sheets will be come based on dividing sheets with 65000 records for one file. I searched google and FME knowledge. There is the similar answer which is using Generic Reader for loading all dynamic sheets. But it is not working using Generic Reader. Thus, I would like to ask the way to load dynamic excel sheets from one file to load into the database.
Userlevel 4
+13
- Contributor
- 3701 replies
-
5 December 2017
Hi @jasonjungict, can you elaborate on how it's not working with the Generic Reader? Are you seeing errors or is the behaviour not what you intended?
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.