+ Reply to Thread
Results 1 to 2 of 2

Data type mismatch excel to update records in ms access

  1. #1
    Forum Contributor
    Join Date
    06-07-2016
    Location
    Manila
    MS-Off Ver
    365
    Posts
    292

    Data type mismatch excel to update records in ms access

    Hi all,

    Im currently doing some project where you can update data stores in ms access via excel

    All is good except my ontime field and target field is not updating “error data mismatch” both fields are in number percentage format

    Below is the code:

    Please Login or Register  to view this content.
    Already tried the % code but still same error. Any help will do. Thanks!

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,909

    Re: Data type mismatch excel to update records in ms access

    If they are numbers, they should not be enclosed in quotes.
    Rory

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Type mismatch error while transferring data from excel to access using adodb
    By sapnaps in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-04-2018, 10:27 AM
  2. Replies: 2
    Last Post: 08-04-2018, 10:26 AM
  3. Excel to update records in MS Access
    By aarona in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-28-2017, 05:29 AM
  4. Data Type mismatch error while using Like in access query
    By teco in forum Access Tables & Databases
    Replies: 5
    Last Post: 01-26-2017, 04:36 PM
  5. Excel to Access import data type mismatch
    By goodlite in forum Excel General
    Replies: 0
    Last Post: 01-23-2017, 11:35 AM
  6. [SOLVED] Excel/Access update records
    By Raanan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-19-2014, 05:14 AM
  7. Data type mismatch - excel userform to access table
    By chinaboy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2012, 08:44 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1