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
<[EMAIL PROTECTED]> 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.
