SQL table Access combo box

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

Guest

Hi all,
What would be the best way to populate combo box from SQL to Access. There
are over 800,000 records in the SQL db (street addresses). AS you can
imagine, just creating a combo box from an ODBC connected SQL table is a bit
sluggish. If you can think of a way in Access (2k,XP) that would be best.
But if you think the best answer is on the SQL side that will work as well.
Thanks,
Nick
 
Nick,

In my experience, ODBC connections from within Excel are faster than Access,
and more reliable. What I do is to use Microsoft Query from within Excel to
make the ODBC connection, and save the Excel workbook (*.xls). In Access,
link (NOT import; that way the data is dynamic and doesn't need refreshing)
to the Excel workbook.

Hope this helps,

Sam
 
Back
Top