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.  |
|
|
