It sounds like a possible data problem to me. Try testing the field
for a numeric value before conversion. Maybe the field contains the
word null or nothing at all?
Regards
Robin.
--- In [email protected], "eileen1309" <[EMAIL PROTECTED]>
wrote:
>
> Hi Brett,
>
> The Excel spreadsheet is generated from a website and is actually
an
> XML file I have no control over the formatting.
>
> What's odd is that it worked before and now all of the sudden
> stopped very weird.
>
> Thanks
> Eileen
>
> --- In [email protected], Brett Collings
> <brett.collings012@> wrote:
> >
> > Eileen, how come you have calculations in Excel that are text
and
> not
> > numeric? That sounds like a good way to be confused before
> linking. I
> > would quite expect then for Access to get confused too.
> >
> > First idea: Can you do anything about it at the Access level?
> Second
> > idea: just import them into your temporary table, don't link
them.
> Then
> > convert.
> >
> > None of that may work, but its a good place to start
> >
> > Brett
> >
> > eileen1309 wrote:
> >
> > > I have an Excel File I am linking to my database. I then have
it
> > > create a temporary table so that I can convert the text fields
> with
> > > numeric values to a currency format but I am receiving an error
> > > stating that it can't convert and it is making all the numeric
> values
> > > null.
> > >
> > > For instance the linked spreadsheet has three fields,
totalValue,
> > > Cost, Compensation all of which are text fields, I set these
to
> be TV
> > > = ccur([totalvalue]), CT = ccur([cost]), and Compens = ccur
> > > ([compensation]) and it is erroring me out stating that it
could
> not
> > > convert the text field to a numeric value.
> > >
> > > Am I missing something?
> > >
> > > Thanks
> > > Eileen
> > >
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------------------------------------
--
> -------
> > > YAHOO! GROUPS LINKS
> > >
> > > * Visit your group "ms_access
> > > <http://groups.yahoo.com/group/ms_access>" on the web.
> > >
> > > * To unsubscribe from this group, send an email to:
> > > [EMAIL PROTECTED]
> > > <mailto:[EMAIL PROTECTED]
> subject=Unsubscribe>
> > >
> > > * Your use of Yahoo! Groups is subject to the Yahoo!
Terms
> of
> > > Service <http://docs.yahoo.com/info/terms/>.
> > >
> > >
> > > ---------------------------------------------------------------
--
> -------
> > >
> >
> > -------------------------------
> > This email message and any attachment(s) is intended only for
the
> > person(s) or entity(entities) to whom it is addressed. The
> > information it contains may be classified as IN CONFIDENCE and
> may be
> > legally privileged. If you are not the intended recipient any
use,
> > disclosure or copying of the message or attachment(s) is
strictly
> > prohibited. If you have received this message in error please
> > notify us immediately and destroy it and any attachment(s).
> > Thank you. The Ministry of Social Development accepts no
> > responsibility for changes made to this message or to any
> > attachment(s) after transmission from the Ministry.
> > -------------------------------
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
