925646_en-US

liliconcom

Data connector

Good morning,

In the source script below, can it be modified to import from a certain line and specify on which line the variable names are located?

The column names are in the third row and the data starts in row 4.

(I cannot modify the source Excel file).

Sincerely

Data Access Re: Connecteur de données

Could you use Excel Import Wizard from File > Open?

Re: Data connector

The Excel file is larger than 150 MB. It takes too long to import using the Excel import wizard.

With the data connector, importing is faster.

Re: Connecteur de données

Hi Françoise, 

If you are able to switch to a CustomSQL statement you may be able to specify the range as part of the table name:

New SQL Query(
	Connection( New Data Connector( ID( "demo_excel" ) ) ),
	QueryName( "Sheet1$" ),
	CustomSQL( "SELECT * FROM [Sheet1$A3:XFD] t1;" ) // Select from cells after A3 and all columns
) << Run;