Hall of Fame
January 10, 2013 at 2:45 pm
Do U know if there is another solution to do this with thousand lines in a file ?
January 10, 2013 at 2:56 pm
Thank U for your answer.
Do U think that there is a solution with excel file source and thousand lines in a EXCEL file ??
January 10, 2013 at 3:26 pm
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?
January 11, 2013 at 1:37 pm
Thank you for your answer.
Ok, I will try your script with csv file.
March 16, 2020 at 7:27 pm
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?
March 16, 2020 at 7:36 pm
Yes... get a better program. 😀
Now I suppose you're going to spam us with one, yes?
March 16, 2020 at 7:44 pm
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.
March 17, 2020 at 12:23 am
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.
Viewing 8 posts - 31 through 38 (of 38 total)
You must be logged in to reply to this topic. Login to reply