Exporting only one row from a spreadsheet into a database in Access

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
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Watch MrExcel Video

Forum statistics

Threads
1,099,006
Messages
5,465,965
Members
406,457
Latest member
Pinky Rose Jordan

This Week's Hot Topics

Top