Hello, I'm a bit new to this so please let me know if I don't make any sense
I've been trying to find a way to create a user friendly import system to upload data in external spreadsheets into my access database via forms.
What I would like to do is for the user to be able to click a button which will prompt them to select the path for the file, accept the file to be temporarily loaded into the database and then for them to be able to map the fields in their spreadsheet to the fields in the database (not necessarily in just one table) using a form I can create.
I know you can use TransferSpreadsheet in a macro but you have to have a pre-determined path (which I can use if I have to), and I've had problems with the field rules in the existing tables. Trouble is I'm very new to all this and self taught so I'm not so good at the VBA programming bit.
Sorry to be a bit vague but does anyone know where I could start, I can't find any examples of this anywhere?
I've been trying to find a way to create a user friendly import system to upload data in external spreadsheets into my access database via forms.
What I would like to do is for the user to be able to click a button which will prompt them to select the path for the file, accept the file to be temporarily loaded into the database and then for them to be able to map the fields in their spreadsheet to the fields in the database (not necessarily in just one table) using a form I can create.
I know you can use TransferSpreadsheet in a macro but you have to have a pre-determined path (which I can use if I have to), and I've had problems with the field rules in the existing tables. Trouble is I'm very new to all this and self taught so I'm not so good at the VBA programming bit.
Sorry to be a bit vague but does anyone know where I could start, I can't find any examples of this anywhere?
