Open dialog for ODBC Database (a97)

Topic

New Reply

Currently I have been manually using the file menu ->Get external data->import files and the dialogbox shows then I select ODBC database from types of files according to my attachment files. What i want to do is, isit possible to create a dialogbox instead of using manual way and so i can select ODBC database and it will open the Select data source.?If yes,pls help….thks

Reply | Quote

Replies

I’m not sure on what you wish to accomplish.

Does this mean you want to select a different Data Source name each time you open the database?
Do you just want to link to the ODBC database or do you wish to import the data into tables in Access?
If you just want to link to the tables of an ODBC source then you only need do it once.

Reply | Quote

Yes, i want to link to the ODBC database

Reply | Quote

When you say you go into ->Get external data->import files <<, don't go into Import Files but go into Link tables instead. As I said before, you only have to do this once to create a link to ODBC tables. The tables are then available under the Tables tab as linked tables.

Reply | Quote

its tht mean whatever records they have added into the table then also as my table will be updated isit?And in future i do not need to use the process again to import the table, is tht correct? If yes, then it should be fine and i hv save my time to import large data every month. thks Why i hv not try use link instead of import…..foolish am i … ..As for Charlotte, thks for your advised .. i take patt advise then….. .

Reply | Quote

You can do some of this from code, but the details of how you connect to an ODBC database are going to vary depending on the type of database. You aren’t trying to connect to an Access database this way are you? I know there’s a listing for it, but that isn’t the way you link to an Access database. You use ODBC for SQL Server, dBase and other formats that don’t provide an alternative method.

Reply | Quote