Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    1

    Question Unanswered: Progress Database Imports

    I am trying to find out if its possible to import excel spread sheets into a progress data base ?

    I only started using progress 4 weeks ago ..

    any links or ideas?

  2. #2
    Join Date
    Jan 2005
    Posts
    3
    Heya there Bardwell,

    Yes you can. Easier to save the Excel workbook as a CSV file.
    From there try doing something like this :

    Code:
    def var vInputField as char no-undo.
    
    input from "drive:\directory\file.csv".
    
    repeat:
        import delimiter ","
            vInputField.
    
        /* you can put your logic in here to do what ever
            you need to do with vInput Field
    
            NOTE: You can have as many input fields as you like...
                      I tend to make a vDummy field for columns 
                      I don't need to use...
    
                      I also tend to use streams for flat file IO, but
                          easier for this example not to.
     */
    
    end.
    
    close input.
    Hope this helps...

Posting Permissions

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