Give the Data Source Name and description.Ĭlick on the Select WorkBook and Browse and select the Excel file which you have created at step 1 ODBC Data Source Administrator – Select WorkBookĬlick Ok ODBC Data Source Administrator Setup 2ĭata Souce will be visible in the List Created ODBC SourceĮnter your email address to subscribe to this blog and receive notifications of new posts by email. In that case you Close the ‘ODBC Data Source Administrator window’ and open “c:\windows\sysWOW64\odbcad32.exe” ![]() Note: If you have 64 bit operating system and 32 bit Microsoft Excel then you might get the Error “ODBC Driver is not found” Error Once you will click on Configure button the ‘Setup’ window will be displayed. Use Excel as ODBC Source ExampleĪdministrative Tools -> Data Sources (ODBC) -> Choose User DSN -> Choose ‘Excel Files’ from the list-> Press ‘Configure’ NOTE: First line of the range of data will become the Column Names of the Table. ![]() Say that this is the created file with name “DB Data.xlsx” Store data in your excel file and save it some location in your system. To Read about how to use this Data Source for reading the Data Click Here
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |