I'm looking for a predeveloped form (buy??) or suggestions to build my own...
that will map an input file into predefined table.
My client's application requires uploading a table into an application. The application will hold the data in a predefined table. The source data will be either a *.CSV or an .XLS / .XLSX file type. The input file will not be in the same structure and the predefined table, so it will need to be mapped before importing.
I've seen many mapping applications that show the input data down the left side of the form. and the target file down the right side of the form.
Any thoughts on where I can get such a form or suggestions on building one.
I'm pretty good with VBA.