Results 1 to 3 of 3

Aggiornare una tabella con dati inseriti in file *.CSV collegato

  1. #1
    CADALPA is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    1

    Aggiornare una tabella con dati inseriti in file *.CSV collegato

    Salve, sono nuovo del forum e anche di programmazione. Vorrei che mi aiutaste a risolvere il mio problema. Dunque: ho un file CSV che contiene estrazioni del lotto aggiornato all'ultima uscita (ogni volta lo scarico da internet).


    .
    Questo file è collegato tramite DATI ESTERNI --- FILE DI TESTO ad access in una tabella.
    .
    Cosa vorrei io?
    .
    Vorrei che ad ogni download del file CSV (aggiornamento estrazione), essendo collegato a access la tabella si aggiornasse in automatico cosi da avere sempre l'ultima estrazione disponibile sia su CSV che su access.

    Non so se serve una macro, una query o cos'altro, non so il procedimento da seguire
    .
    Quello che chiedo però è di spiegarmelo come fossi un bambino delle elementari perché come ho detto sono NOVELLO.

    Vi ringrazio anticipatamente

    CADALPA

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    12,609
    For those in the forum who do not read or understand Italian, here is an English version of CADALPA's post directly from Google translate.

    Code:
    Hi, I'm new to the forum and also to programming. I would like you to help me solve my problem.
     So: I have a CSV file that contains batch extractions updated at the last exit (every time I download from the internet).
    .
    This file is linked via EXTERNAL DATA --- TEXT FILE to access in a table.
    .
    What would I like?
    .
    I  would like every download of the CSV file (extraction update), being  connected to access the table updates
     automatically so as to always have  the last extraction available both on CSV and on access.
    
    I do not know if you need a macro, a query or whatever, I do not know the procedure to follow
    .
    What I ask, however, is to explain it to me as if I were a primary school child because, as I said, I am NOVELLO.
    
    I thank you in advance
    
    CADALPA
    CADALPA, I suggest you write your question(s)/material in Italian, then use Google translate and post in English.

    Give us some details of the extraction from the internet. Also some sample csv data.
    If you told us in plain, simple Italian - translated into simple English what the subject matter
    is and what your expected output should look like, it would help readers understand.
    You may get more focused responses.
    Good luck.

    And as Google translate says in Italian:

    CADALPA, ti suggerisco di scrivere le tue domande / materiale in italiano, quindi
    di utilizzare Google translate e post in inglese.

    Dacci qualche dettaglio dell'estrazione da internet. Inoltre alcuni dati csv di esempio.
    Se ci hai detto in italiano semplice e semplice - tradotto in inglese semplice quale
    sia l'argomento e quale dovrebbe essere il tuo output previsto, aiuterebbe i lettori
    a capire. Potresti ricevere risposte più mirate.
    In bocca al lupo.

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    44,223
    Is each extraction cumulative data? Or only new, edited data? If it is cumulative then just copy over the csv file and retain the same name.
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

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

Similar Threads

  1. Replies: 14
    Last Post: 05-24-2017, 01:22 PM
  2. Replies: 1
    Last Post: 03-03-2017, 08:25 PM
  3. Replies: 13
    Last Post: 12-12-2013, 06:22 PM
  4. Replies: 10
    Last Post: 03-03-2012, 11:17 PM
  5. Replies: 0
    Last Post: 06-24-2009, 02:10 AM

Posting Permissions

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