Am being frustrated some by Access's insistance on importing an Excel
text field as a numeric field whacking some of the values entered in
the field with a #NUM1 error. Access is insisting on linking the Excel
text field in question as a numeric field. Hence the problem. Many of
the values are numbers but there are also a number of alphanumerics in
the column and empty cells. I have tried to fool Access by making the
first few entries alphanumerics, and I have explicitly defined the
Excel column as text.
This would seem to be an Access bug. Anybody have a work around when
linking tables?
Thanks.
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.
