Setup ODBC connection for excel file

The instructions for this setup is for WindowsXP.
The assumption is the excel file is located in c:\EMPData\ folder and named StockCountDataExport.xls. (An empty file is attached at the bottom of this page with the necessary column names)

Step 1: Go to Control Panel -> DataSources(ODBC)->System DSN -> Add-> Microsoft Excel Driver(*.xls). Click Finish

Step 2: Fill in Data Source Name, Description as stockcountexportdata, Version-> Excel 97-2000.
Click on Select Workbook button. On the Select Workbook window select c:\EMPData \StockCountDataExport.xls then click on ok.

The ODBC Data Source is added under System DSN as shown below.

Step 3: Right click on the StockCountDataExport.xls file located in c:\EMPData\. Make sure the Read Only check box is unchecked.

Stephen Boey,
Feb 11, 2011, 1:02 AM