Import list in to a Row Source

[Mike Busch]

How can I take a list from Excel and import it into a Row source list for a
combo box. I have 70 Facilities that I would like to have in a drop-down list
and have them in a excel program. Any ideas thanks in advance.

 

[John Nurick]

Hi Mike,

If you want the row source to be linked to the Excel sheet, just use
query, something like this:

SELECT F1 FROM [Excel 8.0;HDR=No;database=D:\File.xls;].[Sheet1$A2:A71];

Otherwise, select the cells in Excel, then copy and paste into a text
editor (or Paste Special into Word as unformatted text). Then replace
all the newlines with semicolons to get from
Facility1
Facility2
Facility3
...
to
Facility1;Facility2;Facility3;...

Finally, copy and paste the result into the RowSource.