Macro to Export Excel Spreadsheet to Access Table

[NeedSomeSeriousHelp77]

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 = Error Num
H = AC
I = Handoff
J = AF
K = Complete
L = Sub
M = description
N = MSG

All of these columns exist in the Access table as well, and I want to dump in the corresponding columns.

The location of the database is on the C:

I'm not sure what other information is needed.

Thank you!

 

[Fazza]

Maybe like post#5 in http://www.mrexcel.com/forum/showthread.php?t=332472 , which has other approaches too?

 

[NeedSomeSeriousHelp77]

Thank you! I got this to work. Appreciate the help!

 

[Fazza]

well done