Hi,
I asked a question a few weeks/days ago about removing single quotes. I've tried the advice given to me but with no success.
I've imported a spreadsheet from Access to Excel. In the Excel spreadsheet, there are single quotes at the beginning of every cell. At the time, the single quotes didn't affect me at all for what I had to do so I didn't bother with it.
Now, I'm trying to import this Excel spreadsheet back into Access, but Access recognizes every field as a text field because of the single quotes. I have a time field that needs to come over into Access, but can't because of the text field issue.
Does anyone have any advice on either removing the single quotes or finding a way to import the time field into Access? Thanks.
I asked a question a few weeks/days ago about removing single quotes. I've tried the advice given to me but with no success.
I've imported a spreadsheet from Access to Excel. In the Excel spreadsheet, there are single quotes at the beginning of every cell. At the time, the single quotes didn't affect me at all for what I had to do so I didn't bother with it.
Now, I'm trying to import this Excel spreadsheet back into Access, but Access recognizes every field as a text field because of the single quotes. I have a time field that needs to come over into Access, but can't because of the text field issue.
Does anyone have any advice on either removing the single quotes or finding a way to import the time field into Access? Thanks.