Hi All and thanks for reading
Does anyone know of a way to pull the column names from an excel spreadsheet into an array in access?
The reason
I have a download spreadsheet that changes by adding or removing columns every month. I attempting to build a custom import that will deal with the changes.
The Plan
I am going to compare the previous months table's feild names and ordinal positions to the spreadsheet to determine what has changed. Then either move new columns to the end of the spreadsheet (dont care about new data) or insert column (with name) to satisfy the transferspreadsheet routine i already have.
Any better ideas appreciated.
Reply With Quote