Re: Excel import

[Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>]

Matt, you're saying I can use SSIS to import the excel sheet to the i?

On Mon, Sep 18, 2017 at 2:29 PM, Matt Olson <Matt.Olson@xxxxxxxx> wrote:

> SQL Server comes with a full fledge ETL tool you can use to import that
> excel data into your IBM i.
>
> It's called SSIS (SQL Server Integration Services).
>
> That right click menu you are seeing in SQL Management Studio for
> importing and exporting data to any platform uses SSIS under the covers.
>
> IBM sells a full fledged ETL tool called DataStage. You might want to
> check price on it though, I seen a 2 CPU pack was $74k but that was from an
> old price list. For that price you could buy about 72 CPU Core licenses of
> SQL Standard Edition (which includes SSIS as part of the product).
>
> -----Original Message-----
> From: Hoteltravelfundotcom [mailto:hoteltravelfun@xxxxxxxxx]
> Sent: Monday, September 18, 2017 12:52 PM
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Subject: Excel import
>
> In SQL Server studio, they have one very nice feature which I would like
> to know if we have on the i.
> One can import an excel sheet onto the sql server, it will create a table
> and the column names will be the excel names of if blanks they do F1, F2.
> etc.
> would we have this on the IFS?
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD