Upload Template In Access

mws5872

New member
Local time
Yesterday, 19:56
Joined
Jan 26, 2005
Messages
9
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
 
Are you asking about File Dialog? Not sure I understand, please elaborate...
 

Users who are viewing this thread

Back
Top Bottom