Dynamically create and populate staging tables from CSV files

  • Please !!

    Do U know if there is another solution to do this with thousand lines in a file ?

  • Hi Stan,

    Thank U for your answer.

    Do U think that there is a solution with excel file source and thousand lines in a EXCEL file ??

  • I am not sure of what you are asking, but an Excel file with 1000 lines is not a big file. Exporting it to CSV would be trivial.

    Do you know how to export a CSV file from Excel by doing a "File-Save As" then choosing "MS-DOS CSV" as the type?

  • Hi Stan,

    Thank you for your answer.

    Ok, I will try your script with csv file.

  • Dynamically create and populate staging tables from CSV files. Program can't load records that have the apostrophe character . Do you have any solution for that?

     

  • LS2 wrote:

    Dynamically create and populate staging tables from CSV files. Program can't load records that have the apostrophe character . Do you have any solution for that?

    Yes... get a better program. 😀

    Now I suppose you're going to spam us with one, yes?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • I would open the CSV file in Excel and search-and-replace the apostrophe with nothing, then save the revised file as a CSV file that now contains no apostrophes.

  • Stan Kulp-439977 wrote:

    I would open the CSV file in Excel and search-and-replace the apostrophe with nothing, then save the revised file as a CSV file that now contains no apostrophes.

    Apostrophes generally aren't a problem with anything that can handle a CSV.  That's why I think the post was a setup for spam.  I could be wrong.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 8 posts - 31 through 38 (of 38 total)

You must be logged in to reply to this topic. Login to reply