Results 1 to 2 of 2
  1. #1
    Join Date
    May 2005
    Posts
    125
    Provided Answers: 1

    Question Unanswered: Help with Code Please

    Hi

    I need a little help, and have a couple of questions, and I was wondering if you guys could help me.

    This is the start of it, which works fine, it basically imports data from data source supplied by a third party, unfortunatleythe only issue I have with the data is no identifying data to say which site it has come from, in this example the site is (11771), so what in need to do is this, after the data has been imported, I need to update the SiteID Column within the table with the site id, what is the code that I require to carry out the update ???, i cant find it

    Second question: in the path of where the data is located, can the 20090228 be driven from a form e.g. "D:\sites\S11771\[Form1].[Date].vpn\cbrp.csv",

    Public Function Import()

    DoCmd.TransferText acImportDelim, , "Cbrp", "D:\sites\S11771\20090228.vpn\cbrp.csv", True

    Update ????????

    End Function

    Thanks in advance

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Me.Geek = True

Posting Permissions

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