hi the part im missing alot is really the part im stuck on.
for this part
Code:
It should be 

Cmd$ = "Insert Into TableName ( Your field names as above) Values ( The actual values for each field listed in the
i want the values to be entered automatically. its a big long spreadsheet and this will be run on a daily basic and the spreadsheet values will change
is an array the best way to get this done or is there a better way