Importing data using ODBC is similar to the process of importing data from files:
1.Select the folder containing the data that you want to import into the Folders window.
1.Click on Data[Import from Files and Databases] > ODBC Data Source.
2.Select a data source from which you want to import data in the Select Data Source dialog box, or create a new data source.
3.The ODBC Data Import dialog box appears where you can select the columns to import from the tables present in the data source. If necessary, call up Help in the dialog box by clicking on '?'.
4.The import process starts when you press Copy or Link.
Note: Some data formats, such as Microsoft Excel workbooks (extension .XLS), Microsoft Access databases (extension .MDB) and also ODBC data source files (extension .DSN), can also be selected and imported directly as files.