D
DCPan
Hi,
I did some searches on older threads and can't seem to find an answer to this.
I have an access db that compares data from a couple of sources, then
download a spreadsheet of new entries that needs to be manually entered into
an enterprise system.
You would think that those entries could just be copy and pasted into the
GUI, but for some strange reasons, there are leading apostrophe in the
download, even if it is already text.
For example, if the cell in access is "Superman", the downloaded Excel cell
would contain " 'Superman ".
I understand apostrophe is used to store number as text. But why have
apostrophe when it is already text?
Thanks!
I did some searches on older threads and can't seem to find an answer to this.
I have an access db that compares data from a couple of sources, then
download a spreadsheet of new entries that needs to be manually entered into
an enterprise system.
You would think that those entries could just be copy and pasted into the
GUI, but for some strange reasons, there are leading apostrophe in the
download, even if it is already text.
For example, if the cell in access is "Superman", the downloaded Excel cell
would contain " 'Superman ".
I understand apostrophe is used to store number as text. But why have
apostrophe when it is already text?
Thanks!