Hello everyone,
I would like to import in Access an Excel 2007 file. The problem comes because it has:
- several sheets;
- every sheets with one (or more in some cases) named ranges.
The user, by an advanced form, import in a table not only the desidered Excel file (by FileDialogPicker), but the specific named range. In other words, I need to build a form where the user can select an Excel file, then choose from a list of sheets or named ranges contained in it.
What solutions can you propose me?
Many thanks for your attention and help.
Bye.
Riccardo