Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009
    Posts
    2

    Unanswered: SQL to update MS Access table based on values in an external tab delimited file.?

    I have no experience in MS Access. But briefly, what I want to do is to update the Quantity value in my MS access table to match that of the external table based on a common product identifier (SKU) which has a heading called "Record_ID" in the Access table and "SKU" in the external file.
    If the quantity was changed, then I would like to enable (check mark) the checkbox in the upload field AND if the quantity is 0 then I'd like change the "Status" to "Sold" instead of "Available."
    Please check the following video which I created to describe what I want to do. I hope it is clear enough:
    Access Database Question

    Thank you for help.

  2. #2
    Join Date
    May 2008
    Location
    Raleigh, NC
    Posts
    151
    I would suggest the following;
    Assuming the external tab delimited file remains consistant in format then you can have Access link to that table and then you can have a macro that looks at that table and runs the update functions you are talking about. Sounds simple enough but you'll have a bunch of code to write.

    Good luck, Stu
    --If its free, take it for what its worth!

Posting Permissions

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