Microsoft Access x Talend

[Anonymous]

I need to extract from a database access .mdb multiple tables, generating a .csv file for each table and then uploading to an azure blob. For this I used an access -> tFilleOutputDelimited -> tAzureStoragePut connection. Is there a component that can pull multiple tables at once to create multiple .csv files?

Note: The way I'm doing I have to do the same procedure for each table separately.

[fdenis]

if you have a file with the liste of table to extract.
then use a tFileInput, tFlowToIterate then add iterate Link to RoadShow.
regards,

[Anonymous]

Thanks for the help, but that still does not solve. I have a .mdb with many tables, where I need to have an output in .csv file, however for each table a .csv file is generated

[fdenis · Accepted solution]

on mdb you must have table liste.
try to use "SELECT * FROM MSysObjects WHERE Type=1 AND Flags=0"
then you will retrieve table liste.

[Anonymous]

Thank you very much