Results 1 to 2 of 2
  1. #1
    za20001 is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    Apr 2011
    Posts
    5

    "Calculated" Text Fields -- Linked Table FROM excel INTO access


    I used FIND and MID to clean a dataset in Excel.

    =FIND(":", B7, 60) etc.

    =MID(B7, 88, (D7-C7)-1) etc.

    When I link Access 2000 to Excel (2010), Access grabs every field correctly except the MID field. Access displays nothing in the MID column.

    Any thoughts on why this might be, and how I can get the MID function to populate?

    Thanks!

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    don't know.

    would try this.... if G7=MID(B7, 88, (D7-C7)-1)

    and G7 isn't linking....

    try making an H7=G7

    and see if H7 links....it might work in H7 having a value (of G7) rather than a formula...and maybe will work....

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 02-13-2013, 02:35 PM
  2. "Group By" causes "ODBC--Call Failed" error
    By kaledev in forum Queries
    Replies: 1
    Last Post: 03-09-2011, 02:43 PM
  3. Replies: 0
    Last Post: 11-30-2010, 12:23 PM
  4. Replies: 1
    Last Post: 05-13-2010, 10:50 AM
  5. Replies: 21
    Last Post: 06-03-2009, 05:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums