This is my first time in access.
Converting from one payroll system to another via Office 2003.
I need to
1) Load spreadsheet data from source payroll system. (Done: I've chosen to create and populate an Access database)
2) Build .CSV files based on. but different in layout from, the Access database above.
3) Translate some of the values from the source system (e.g. tax code) to its equivalent value in the taget .CSV
My reference is Wiley publications Access 2003 Bible. Am I looking at developing a complex SQL statement against my source tables per target .CSV?
If so, how do I get my translations done?
Again, this my first foray into Microsoft other than vb.net
Appreciate your help.
Regards
Grnadpa (Grandpa) Brian
Converting from one payroll system to another via Office 2003.
I need to
1) Load spreadsheet data from source payroll system. (Done: I've chosen to create and populate an Access database)
2) Build .CSV files based on. but different in layout from, the Access database above.
3) Translate some of the values from the source system (e.g. tax code) to its equivalent value in the taget .CSV
My reference is Wiley publications Access 2003 Bible. Am I looking at developing a complex SQL statement against my source tables per target .CSV?
If so, how do I get my translations done?
Again, this my first foray into Microsoft other than vb.net
Appreciate your help.
Regards
Grnadpa (Grandpa) Brian
