If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Other > Progress Database Imports

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-06-05, 05:19
Bardwell Bardwell is offline
Registered User
 
Join Date: Dec 2004
Posts: 1
Question 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?
Reply With Quote
  #2 (permalink)  
Old 01-10-05, 19:21
JohnZantey JohnZantey is offline
Registered User
 
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...
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On