Post reply

Tools to load fields into a query

  • June 9, 2016 at 1:28 pm

    #326865

    Hello, I'm tasked with creating a query that has 700 fields. I have an excel doc that has the required fields (only 30 are actual fields mapped to our tables)...the rest will be blank values with headers. Is there a tool that will let me import those headers so that I don't have to type them all?

  • June 9, 2016 at 1:31 pm

    #1884225

    You could use SSIS for that. To create the packages more easily, you could use the Import/Export wizard.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • June 9, 2016 at 4:45 pm

    #1884266

    Is this a tool in SQL Server?

  • June 9, 2016 at 10:48 pm

    #1884278

    Yes.

    Import/Export wizard

    SSIS Packages

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 4 posts - 1 through 3 (of 3 total)

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