ketangarg86
New Member
- Joined
- Jul 31, 2014
- Messages
- 11
Hi,
I am working on a project where I need to upload selected data from multiple sheets of an excel file. Here is an example of what I want.
1. I want to create a table in Access with around 10 columns
2. Column 1 should be populated with the date field found in A2 cell of sheet 1 of the excel file
3. Column 2-5 should be populated with the columns B2-E200 in sheet 2 of the excel file.
4. Columns 6-7 would be populated based on values from columns 1-2 of the table. Basically Column 6 should be Column 1 date plus 60 days.
5. Column 8-10 would be user generated after the excel is imported and the user should have the ability to attach around 5 files to each row.
Could you please let me know if this is possible. Would really appreciate it.
Thanks.
I am working on a project where I need to upload selected data from multiple sheets of an excel file. Here is an example of what I want.
1. I want to create a table in Access with around 10 columns
2. Column 1 should be populated with the date field found in A2 cell of sheet 1 of the excel file
3. Column 2-5 should be populated with the columns B2-E200 in sheet 2 of the excel file.
4. Columns 6-7 would be populated based on values from columns 1-2 of the table. Basically Column 6 should be Column 1 date plus 60 days.
5. Column 8-10 would be user generated after the excel is imported and the user should have the ability to attach around 5 files to each row.
Could you please let me know if this is possible. Would really appreciate it.
Thanks.
