ODBC Connect to Excel File

Question

3.24K viewsMarch 27, 2006DataLink

0

numberpro 360 March 27, 2006 0 Comments

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?

1 Answer

score 0 · Answer 1 · 2006-03-27T23:03:15+00:00

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

1 Answer

Latest Questions