Need a utility that can integrate with ODBC link and retreive selected tables and change them into a Access database instead.
Also need to be able to make some SQL queries as merging several tables together and then create a custom table names.
The program needs a have a nice interface that's easy for users to access and users can click on the tables they want to retreive
The program also needs to be able to display some information about the tables on a field next to table if it's retreiving if the table names are matching a [url removed, login to view]
If the ODBC links finds the table for example:
"[url removed, login to view] Descr: Property data"
If there's no match then of course it there would be no description displayed.
16 freelancere byder i gennemsnit $141 på dette job
You can use DAO for creating or modifying the ODBC link within MS Access database programmatically. This will be a very quick solution. Need a few hours only. I just need to have your sample of database.
I have done the similar interface with oracle to sql server, FoxPro Database to Access or Sql Server etc. Done the interfacing with SAP and Oracle Apps also. Need 16 hours to deliever future proof system.