Quote Originally Posted by asingh
As Norie has suggested...above mentioned are good methods. They all get data into the system, keeping in mind structures and constraints.

Yes, the above methods can also be "VBA'ed"....!

1. What is your source data format.....xls, csv, txt.
2. How repititive will be the task.
3. Is the source data dynamic...in the sense will the row counts change.
4. Will columns change too [get tricky]...

regards,
asingh
asingh,
1. The source is the SAP tables
2. The task will repeat once or twice a week
3. The row counts will change (increase)
4. Columns will not change