A piece of code could do?

[ebiscaro]

I am populating my database with data from an excel spread sheet.

I am now importing the data by cutting and pasting them in a table. I would like to be able to import the data directly from the excel spread sheet, without opening it. I have found out that there is a macro to do that but the macro has a fixed Range say A1:BO12. In reality this range is not fixed. Is there a way to tell Access to import form A1 until a blank cell or something similar? Thank you in advance I went already a long way since I strted thank to you.

 

[Fornatian]

Why not use a linked table with an update query if the data 'needs' to be imported ?

 

[ebiscaro]

why not

I guess I will do something similar to what you suggested. I Import the data given a large range of the spreadsheet, then I append them to the table using a appen query where criteria for the field containing the index key is: Is Not Null.
Still it would be more elegant, I guess, to have a code that can find the exact range.
Thank you