Extracting data from Multiple Access Tables

* Version Number = Advanced ETL Processor Ent. 4.2.3.5

* Repository type = MS Access 2007

* Database type you are working with. = .MDB

* OS = Windows 7

1.I am looking for specific step by step instructions on how to read/combine data from 2 tables in the same Access database.I can get them both to show up in the source table choice field in the reader but cannot find specific instruction to extract data from both tables at once. What I am trying to do is validate use an ID number in my customer table to validate only address records with a valid ID number in another table which contains name and address for customer.

2. I am also being restricted somewhere to a 200 record output of data. I would like to be able to write all data to a CSV file at one export.

Thank you for your time in advance.

1. Several ways of doing it
If both of your tables in the same database you can just use sql as data source and do it this way
Select from customers where address_id not in (select address_id from adresses)

or

Select from customers where address_id in (select address_id from adresses)

Or

you can use in InList function within Data validator to validate the data

by default you have something like this

Data Reader=>Data Validator => Data Transformer => Data writer

Double click on Data validator and add InList function
Double click on InList function and use something like this sql as a source

select distinct address_id from adresses

Please watch our OnLine tutorials they will give you a good start

2. Double lick on data reader object, click on Data restriction tab and check you settings

Thank you! I finally found the bullet point that activates the SQL query monitor and have 10k records out now.The online tutorials have given me a great head start but I was lost without the SQL query