Forum Discussion
Save Excel range to Access Database
mathetes sorry, an important detail was missing: Imagine that this Excel spreadsheet works as a register, in which a user will fill in and that the values entered must be transported to Access.
Again, I haven't used Access in decades. You're using Access, according to your first message, because it is "more robust." Is there some reason, then, why the data entry can't be done directly into Access? Why is the entry into Excel--if it's only data entry--even a necessary step.
I'm sure there's an Access community corresponding to this one for Excel--may I suggest you pose the question there? I'd be surprised if it weren't possible to dispense with Excel as a component in your process of data collection.
Although it's also possible--entirely possible--that another person here in the Excel techcommunity will have a solution for you.