Recent content by sean42

Good idea and one which I considered but there aren't always header names in the raw file. I was hoping there might already be a "ready made" wizard type function available. Eg, Choose Excel Workbook, preview the chosen book.....Choose column for Unit Sales...choose column for Value Sales etc

Unfortunately not, because the headings in the raw data are different retailer to retailer and the headings do not match the master headings I want to use when importing. Thats why I need to map them

Good morning, interesting problem I hope. (I am using Office 2007) At the moment, I have an Access table which is basically a spec for how different retailers raw excel files can be read into an Access Table. It lists the Field Name that will be used when importing into the Access table, the...