Import list in to a Row Source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top