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]>
>
> * 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.
