I have an excel work book with y data columns, each of which currently constitute a row for x records.
I want to create a database table that has 3 columns:
1. The 1st column of each existing row
2. The name of the existing column
3. The value of the column
Could anyone possibly supply a VB algorithm that will open up an existing Excel workbook, and put the output in a new one?