VB module to add a field to a table

[Access nubie]

Hello. I download data into an excel file every month. i bring that file into access, then add 2 fields, one as a text type and the other as a number type. after that, several queries need to be run.

since it is the same format with the same field names every month, I'd like to automate the process so someone else can just run a macro to do this. Can someone advise me how to build a module/macro to automatically add the 2 fields with specific field names & data types?

thanks.

 

[jzwp22]

I need a little clarification. Are you adding two new fields to a table & then appending data or are you adding two new records each time? Could you provide some more specifics regarding your table structure and possibly some example data? With that we might be able to better help you reach a solution.