sql - Excel to Access, change data types as part of a button's on click action -

i have 2 reports run in sap (i have user level permissions) twice daily need end in access. current process looks this:

(1) run report one, select fields need, export excel. (2) run saved import within access table. (3) switch table design view can edit data types sync table intend update. (4) run append query.  (5) rinse , repeat report 2. 

since i'm looking delegate task user i'd button changes process to:

(1) run report one, select fields need, export excel. (2) click "import, change data type , append" button.  (3) rinse , repeat report 2. 

the excel document's formatting looks this:

txtfield1 txtfield2 txtfield3 txtfield4 txtfield5 dateandtimefield1 

it uses different naming conventions access.

access needs:

txtfield1 txtfield2 numberfield1 numberfield2 numberfield3 dateandtimefield1 

i can excel document access using macro add append query button's actions. can't append table want unless data types sync.

how switch data types , (if using vba) column headings on imported document part of button's on click action?

maybe try range("a1").numberformat or, range("d2").value = val(range("c2").value) val() function.