Hi All,
It's been awhile since I have posted but I am in the process of making an upload template in Access.
I want to use an excel file containing the following fields.
Year
Sales Person
User Role
Goal type
Month (Jan - Dec) listed as columns across the file.
The top 4 fields will create a unique key to upload into the database. Obviously each of these PK belong to different tables.
How would one go about creating a button to explore where the file is that you want upload in access?
Also, how would you go from column format to row format for the dates for the goal amounts per month? If that is not clear let me know. I'd like for users to upload column for months but in the DB it is represented as months column with each month as a value in a field.
thanks
It's been awhile since I have posted but I am in the process of making an upload template in Access.
I want to use an excel file containing the following fields.
Year
Sales Person
User Role
Goal type
Month (Jan - Dec) listed as columns across the file.
The top 4 fields will create a unique key to upload into the database. Obviously each of these PK belong to different tables.
How would one go about creating a button to explore where the file is that you want upload in access?
Also, how would you go from column format to row format for the dates for the goal amounts per month? If that is not clear let me know. I'd like for users to upload column for months but in the DB it is represented as months column with each month as a value in a field.
thanks