Introfield
Instructor
My client wishes to regularly import a "campaign" from Thompson Business Search Pro (.csv). I have two problems...
1. A date field in the destination (Access 2000) table is a required field. The .csv file does not contain such a field (I am happy for current date to be inserted at import).
2. My second problem is that field names differ from bsp to my access tables.
I currently perform the export/import via Excel and use an Excel macro to clean up the data (and insert the required date field) before sending to Access. This works but is not ideal - I'd like to skip the Excel bit.
Also, the BSP campaign occasionally produces an irregular number of fields (presumably when there is data in that field). I can see how to overcome most issues with the specifications option on the "get external data" dialogs but can anyone please help with these two?
1. A date field in the destination (Access 2000) table is a required field. The .csv file does not contain such a field (I am happy for current date to be inserted at import).
2. My second problem is that field names differ from bsp to my access tables.
I currently perform the export/import via Excel and use an Excel macro to clean up the data (and insert the required date field) before sending to Access. This works but is not ideal - I'd like to skip the Excel bit.
Also, the BSP campaign occasionally produces an irregular number of fields (presumably when there is data in that field). I can see how to overcome most issues with the specifications option on the "get external data" dialogs but can anyone please help with these two?