1) Set the "OpenRowset" Custom Property of your Excel Connection
2)Right-click your Excel connection > Properties; in the Properties window, look for OpenRowset under Custom Properties).
3) To ignore the first 6rows in Sheet1, and import columns A-M, you would enter the following value for OpenRowset: Sheet1$A7:M
4) You can also specify a row number if you like for end row i.e. M, if you know where records in excel will end
2)Right-click your Excel connection > Properties; in the Properties window, look for OpenRowset under Custom Properties).
3) To ignore the first 6rows in Sheet1, and import columns A-M, you would enter the following value for OpenRowset: Sheet1$A7:M
4) You can also specify a row number if you like for end row i.e. M, if you know where records in excel will end
No comments:
Post a Comment