kevlray
Registered User.
- Local time
- Yesterday, 22:44
- Joined
- Apr 5, 2010
- Messages
- 1,046
I had been using DoCmd.TransferSpreadsheet to import data into a table. But now the user wants to change one of the column headings in Excel to a name that does not match the field name of table. I found some code that looked like it would work (using ADODB), but we are on Office 2016, 64 bit and apparently Microsoft does not support using ADODB anymore. So is there another solution? Also running on Windows 10 if that matters.