P
Peter Jamieson
G'day Steve,
I followed your suggestion and tested the recommended fix with the following
as test surnames: True, False, On, Off, Yes, No.
They all passed with flying colours and were transferred to Access as
written.
I take your point re data transfer: my useage is just out of previous habit
not considered choice....one of these days I'll recode but at the moment it
works well (at least until Mr True came along!)....sleeping dogs and all
that...!
Many thanks for your help!
Cheers, Peter J.
(Below is quoted from Steve Schapel's email in earlier discussion)
As you possibly know, the type of thing which is called a macro in Excel
is called a VBA procedure in Access, where an Access macro is a very
different creature altogether. To achieve your purpose within Access,
either with a macro or with a vba procedure, would be relatively simple,
possibly involving a TransferSpreadsheet action followed by running an
Append Query. Your method of doing this from within Excel is in essence
based on processing the data cell by cell, so I suppose data types are
assessed cell by cell, rather than column by column, in which case the
True and False names are being evaluated as being Boolean rather than
Text type, and therefore assuming the values -1 and 0 as you would
expect for Boolean data. I would like to know if the same would apply
if you had people named Yes or No or On or Off. Still, the result you
are getting is not what I would have expected, and it is fascinating. I
am passing the information along.
I followed your suggestion and tested the recommended fix with the following
as test surnames: True, False, On, Off, Yes, No.
They all passed with flying colours and were transferred to Access as
written.
I take your point re data transfer: my useage is just out of previous habit
not considered choice....one of these days I'll recode but at the moment it
works well (at least until Mr True came along!)....sleeping dogs and all
that...!
Many thanks for your help!
Cheers, Peter J.
(Below is quoted from Steve Schapel's email in earlier discussion)
As you possibly know, the type of thing which is called a macro in Excel
is called a VBA procedure in Access, where an Access macro is a very
different creature altogether. To achieve your purpose within Access,
either with a macro or with a vba procedure, would be relatively simple,
possibly involving a TransferSpreadsheet action followed by running an
Append Query. Your method of doing this from within Excel is in essence
based on processing the data cell by cell, so I suppose data types are
assessed cell by cell, rather than column by column, in which case the
True and False names are being evaluated as being Boolean rather than
Text type, and therefore assuming the values -1 and 0 as you would
expect for Boolean data. I would like to know if the same would apply
if you had people named Yes or No or On or Off. Still, the result you
are getting is not what I would have expected, and it is fascinating. I
am passing the information along.