Dynamically create and populate staging tables from CSV files

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Stan Kulp » Dynamically create and populate staging...

34 posts, Page 4 of 4

«««1 2 3 4

Dynamically create and populate staging tables from CSV files

Rate Topic

Display Mode

Topic Options

Author

Message

Lidou123

Posted Thursday, January 10, 2013 2:45 PM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 3:28 PM
Points: 43, Visits: 145

Please !!

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

Post #1405652

Lidou123

Posted Thursday, January 10, 2013 2:56 PM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 3:28 PM
Points: 43, Visits: 145

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 ??

Post #1405667

Stan Kulp-439977

Posted Thursday, January 10, 2013 3:26 PM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 9:12 PM
Points: 78, Visits: 596

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?

Post #1405683

Lidou123

Posted Friday, January 11, 2013 1:37 PM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 3:28 PM
Points: 43, Visits: 145

Hi Stan,

Thank you for your answer.

Ok, I will try your script with csv file.

Post #1406248

« Prev Topic | Next Topic »

34 posts, Page 4 of 4

«««1 2 3 4

Permissions