gojets1721
Registered User.
- Local time
- Today, 10:33
- Joined
- Jun 11, 2019
- Messages
- 429
I am sent an excel file of data from another department (see attached example) and I'm trying to import it into Access and clean it up. I expected this to be very simple but the excel file's formatting is horrific.
Firstly, the '1st question' column has both the question and response listed in it. So in theory, I'd like to completely get rid of the question and either have it say 'yes' or 'unanswered'.
The issue is that you'll notice in the Excel file that there's like 40 spaces at the end of the last character in that column. It's bizarre. I try to use the trim function in Access to get rid of that and it doesn't work.
Any suggestions?
Firstly, the '1st question' column has both the question and response listed in it. So in theory, I'd like to completely get rid of the question and either have it say 'yes' or 'unanswered'.
The issue is that you'll notice in the Excel file that there's like 40 spaces at the end of the last character in that column. It's bizarre. I try to use the trim function in Access to get rid of that and it doesn't work.
Any suggestions?