Strategy for getting data from Access and Excel databases
Posted on 2002-04-14
I need to get data from Access and Excel databases for interpretation in a VB application. The VB application is set up to work with the data in an array, and I can fill the array with data from an Access database or Excel spreadsheet providing I know EXACTLY what the field headings are going to be. For example, I can populate the array with data from a database or spreadsheet with a field called UnitID. However, if I try populating the array from a database or spreadsheet where the same parameter is called Unit#, I have to (a) be aware of the different field names in the databases and (b) provide code to acccomodate these differences. Does anyone know of a way where the user can first identify the fields in a given database, then select or rename them for download to the VB application. I need this because users will want to use their own databases with my application, and I don't want to customise the application for each and every user.
Is there a strategy for doing this?
Any help will be appreciated..
100 points to start with....