Hi,
I have an issue where I need to import an excel sheet and then query the table. However they keep changing the headings of the spreadsheet and I then need to change my vba code.
I was thinking if I could read the first line of the spreadsheet (which has the field names), then use this information to create all the fields in my table.
Any ideas of how it can be done.
Peter
I have an issue where I need to import an excel sheet and then query the table. However they keep changing the headings of the spreadsheet and I then need to change my vba code.
I was thinking if I could read the first line of the spreadsheet (which has the field names), then use this information to create all the fields in my table.
Any ideas of how it can be done.
Peter