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