Importing specific rows and columns

[asmores]

I am currently building a database for a team to append general item information in excel to a master file in access. Typically i would like to build this in a form page within the database but there seems to be an overwhelming fear of access in my workplace. I have an Import Mod the seems to do the trick in some of my older databases but currently it pulls the entire sheet. For this database i would like to pull only A5:G65000. This will allow me to add direction cells above and notes to the right for my novice users. Does anyone have any ideas, suggestions, or code that can help me with this?



Thank you,

[JoeM]

Yes, instead of importing by Sheet name, you can import by named ranges. So in Excel, highlight and name your range A5:G65000, and then use that in your Import routine.

[rpeare]

The docmd.transferspreadsheet function allows you to import ranges of cells as well if you are looking to do it via VBA.