Using excel second row as the column header

#1

While loading excel, By default first row is the column header.
Is is possible to specify the second row as the column header?

Thanks

#2

"pm" wrote:

Quote:

While loading excel, By default first row is the column header.
Is is possible to specify the second row as the column header?

Thanks

Yes.
using 'Transform Data Task' you can select where to start row on 'OPTIONS'
tab 'first row'

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts