How do I import a CSV data into an Access DB?

Discussion in 'ASP General' started by john_aspinall@yahoo.co.uk, Jul 21, 2006.

  1. Guest

    For a kick off sorry if this is the wrong forum, Ill go on the Access
    one if Im not on the right board!

    Anyways, Ive got a problem and am not sure if its going to be solved
    programatically using ASP or not.

    Here's the overview:

    Im building an eCommerce web site using ASP. It has an Access DB at
    the back end. Im receiving the Product info from a series of CSV
    files. Ive created a Table in Access called 'Products' and the two
    fields which concern me are called 'ProductID' and 'Price'. The
    product prices change regularly, sometimes quaterly. The updated
    prices will be received in the CSV file.

    Here's the problem:

    I want to somehow get the 'Prices' field in the datbase to be updated
    automatically whenver a new CSV file comes in, I dont want to manually
    type all the updated prices.

    How would I get this done? Can it be done in Access or would I have to
    get some sort of ASP program code to do it? Im not a programmer so
    would appreciate an 'idiots guide' if poss!

    Cheers....John
     
    , Jul 21, 2006
    #1
    1. Advertisements

  2. wrote:
    > For a kick off sorry if this is the wrong forum, Ill go on the Access
    > one if Im not on the right board!
    >
    > Anyways, Ive got a problem and am not sure if its going to be solved
    > programatically using ASP or not.
    >
    > Here's the overview:
    >
    > Im building an eCommerce web site using ASP. It has an Access DB at
    > the back end. Im receiving the Product info from a series of CSV
    > files. Ive created a Table in Access called 'Products' and the two
    > fields which concern me are called 'ProductID' and 'Price'. The
    > product prices change regularly, sometimes quaterly. The updated
    > prices will be received in the CSV file.
    >
    > Here's the problem:
    >
    > I want to somehow get the 'Prices' field in the datbase to be updated
    > automatically whenver a new CSV file comes in, I dont want to manually
    > type all the updated prices.
    >
    > How would I get this done? Can it be done in Access or would I have
    > to get some sort of ASP program code to do it? Im not a programmer so
    > would appreciate an 'idiots guide' if poss!
    >
    > Cheers....John


    You cannot do this in ASP. Access has builtin functionality to import data.
    You should post to an Access group for details. You will need to combine
    this functionality with a program that will periodically check a folder for
    new files to be imported. You will need a programmer for this. It is not a
    task for an "idiot" ;-)
    --
    Microsoft MVP - ASP/ASP.NET
    Please reply to the newsgroup. This email account is my spam trap so I
    don't check it very often. If you must reply off-line, then remove the
    "NO SPAM"
     
    Bob Barrows [MVP], Jul 21, 2006
    #2
    1. Advertisements

  3. Guest

    10/4. Ill post on an Access forum.

    The Idiot. ;-)

    Bob Barrows [MVP] wrote:
    > wrote:
    > > For a kick off sorry if this is the wrong forum, Ill go on the Access
    > > one if Im not on the right board!
    > >
    > > Anyways, Ive got a problem and am not sure if its going to be solved
    > > programatically using ASP or not.
    > >
    > > Here's the overview:
    > >
    > > Im building an eCommerce web site using ASP. It has an Access DB at
    > > the back end. Im receiving the Product info from a series of CSV
    > > files. Ive created a Table in Access called 'Products' and the two
    > > fields which concern me are called 'ProductID' and 'Price'. The
    > > product prices change regularly, sometimes quaterly. The updated
    > > prices will be received in the CSV file.
    > >
    > > Here's the problem:
    > >
    > > I want to somehow get the 'Prices' field in the datbase to be updated
    > > automatically whenver a new CSV file comes in, I dont want to manually
    > > type all the updated prices.
    > >
    > > How would I get this done? Can it be done in Access or would I have
    > > to get some sort of ASP program code to do it? Im not a programmer so
    > > would appreciate an 'idiots guide' if poss!
    > >
    > > Cheers....John

    >
    > You cannot do this in ASP. Access has builtin functionality to import data.
    > You should post to an Access group for details. You will need to combine
    > this functionality with a program that will periodically check a folder for
    > new files to be imported. You will need a programmer for this. It is not a
    > task for an "idiot" ;-)
    > --
    > Microsoft MVP - ASP/ASP.NET
    > Please reply to the newsgroup. This email account is my spam trap so I
    > don't check it very often. If you must reply off-line, then remove the
    > "NO SPAM"
     
    , Jul 21, 2006
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Andrew J Gray
    Replies:
    1
    Views:
    9,362
    Teemu Keiski
    Mar 4, 2004
  2. darrel
    Replies:
    6
    Views:
    13,780
    darrel
    Mar 8, 2006
  3. Replies:
    2
    Views:
    8,953
    M.J. Dance
    Aug 28, 2006
  4. Dave
    Replies:
    4
    Views:
    2,309
    Tom Forsmo
    Oct 23, 2006
  5. Tintin92
    Replies:
    1
    Views:
    2,120
    Andrew Thompson
    Feb 14, 2007
  6. ÊØÖê´ýÍÃ

    problem:import csv data

    ÊØÖê´ýÍÃ, Sep 13, 2011, in forum: Python
    Replies:
    2
    Views:
    345
    Miki Tebeka
    Sep 13, 2011
  7. Cousin Stanley
    Replies:
    1
    Views:
    205
    pyplexed
    Feb 20, 2013
  8. rusi
    Replies:
    1
    Views:
    250
    Peter Otten
    Feb 21, 2013
Loading...