Experts just solved an issue for me where I needed to convert data to be viewed via an Excel file from a single row to a single column.
Now I have to do just the reverse. I have a form that I use to select the Excel file that looks like...
But I now need to make it look like:
How can I do this? The reason is because I'm going to write the values to a temp table via:
DoCmd.TransferSpreadsheet acImport, 10, "tblTempNotesImport", Me.txtFileName, True