+ Reply to Thread
Results 1 to 2 of 2

MS access if exist update , else append table.

  1. #1
    Registered User
    Join Date
    04-06-2021
    Location
    Doncaster
    MS-Off Ver
    2019
    Posts
    2

    MS access if exist update , else append table.

    Hi all,
    For some reason, this code below won't work, I tried to figure it out but it seems I am missing something.
    Please Login or Register  to view this content.
    Error shows
    Untitled.png
    Last edited by ingus16; 07-11-2022 at 04:47 PM.

  2. #2
    Registered User
    Join Date
    04-06-2021
    Location
    Doncaster
    MS-Off Ver
    2019
    Posts
    2

    Re: MS access if exist update , else append table.

    Thread can be closed I guess because Access does not have stored procedures. 'If Exists' is T-SQL feature. However is it possible IF ELSE ?
    I will leave it here for future researchers
    Last edited by ingus16; 07-11-2022 at 04:56 PM.

+ 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. Running an access append query with parameters from Excel. Access version 2010
    By anthony1312002 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2017, 04:48 PM
  2. Append new data from an Access Query to a table
    By cmorten82 in forum Access Tables & Databases
    Replies: 2
    Last Post: 11-10-2016, 12:20 PM
  3. Update and Append Entire table in Access
    By Yoyo120 in forum Access Tables & Databases
    Replies: 7
    Last Post: 06-06-2014, 05:15 AM
  4. access append query error - PC hang
    By ewong in forum Access Tables & Databases
    Replies: 1
    Last Post: 09-17-2012, 01:54 PM
  5. Update & Append Access Table Using Excel Macro - ADO
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2010, 04:49 AM
  6. How do I append data from an excel spreadsheet to a access db
    By Nishen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2006, 03:15 AM
  7. Paste Append from Excel to Access
    By ibeetb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2006, 12:35 PM

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