1

Topic: To import in ACCES a part of the data from book EXCEL

Good afternoon!
I ask the help in the code. I.e. code VBA is necessary.
Problem essence:
1. I have a file excel (in nesting), and only in such type - i.e. there are the incorporated cells and grouping.
2. Accordingly, stupidly to import to the table access it is impossible. And it would be desirable))
3. How an output - to import to the table access only the necessary data (in a file - selected yellow)? I.e. since 6th line
4. The file lies :\TEMP\test.xlsx
At the mind does not suffice to write such macro sad
I ask the help from community!
Thanks!

2

Re: To import in ACCES a part of the data from book EXCEL

SELECT *
FROM [TDSheet$A6:O20] IN ' C:\Temp\test.xlsx ' [Excel 12.0; HDR=No; IMEX=1];

3

Re: To import in ACCES a part of the data from book EXCEL

vova626;
Import to the intermediate table with columns F1, F2..., then request transfer the necessary data to the work table