SQL - Need quick import script to import flat file with text qualifier
Budget: $30 – $250 USD
Hello. I have a comma delimited data file WITH double quotes as a text qualifier. I need a T-SQL Script to import this data file as I will be receiving these on a regular basis in the future.
Text qualifier is important because the PARTY field contains names with a comma: "SMITH, JOHN"
Sample is attached. I need this within the next few hours if possible.
Text qualifier is important because the PARTY field contains names with a comma: "SMITH, JOHN"
Sample is attached. I need this within the next few hours if possible.