excel2007uk
New Member
- Joined
- Jul 13, 2018
- Messages
- 13
Im trying to find a way of exporting one row of data from a spreadsheet into a database in Access. I ideally don't want access to open in this process as it sometimes causes everything to not respond.
I had though about a simply recording a macro to copy & paste one row into access but I think this can only be done by opening it.
It also must be done from excel & not access.
Can anyone help? Even if you can give me ideas on what I could use or any links that would be very helpful. Thank you in advance
I had though about a simply recording a macro to copy & paste one row into access but I think this can only be done by opening it.
It also must be done from excel & not access.
Can anyone help? Even if you can give me ideas on what I could use or any links that would be very helpful. Thank you in advance
