Hi,
I am attempting to build a macro that will take the data in the current Excel spreadsheet, and dump it in the same format in a Access database table.
The Excel spreadsheet has 14 fields and about 35000 rows.
Column A = Index
B = Trans Date
C = Client
D = Plan
E = Member
F = Unit
G =...