ODBC Connect to Excel File

3.32K viewsDataLink

Ok, I might be asked a silly question, but here it is:

When I select an ODBC connection to an Access file, there is no problem. In fact, it works great! I see all the columns and selection is easy. When I try the same thing with an Excel file, I can pick the file from the ‘browse’ button, but when I go to select the columns, nothing shows up. I mean that there are no column for me to select. What is going on here?


You need to range name the table(s) in the Excel file. When you do that, the ODBC link will treat the range-named selections as tables with the first row as column headers. Then you can choose columns/fields as needed.


Latest Questions