ODBC Connect to Excel File

3.32K viewsDataLink
0

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?

0

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.

Chris

Latest Questions