Want subset of large db table and not load the entire table into access

  • Thread starter Thread starter keconklin
  • Start date Start date
K

keconklin

Hello,

How do I load a subset of a table from an ODBC database without
linking or importing the entire table? I tried a select into
statement, but it didn't work. Also, excell allows to do a query to
load info into a worksheet table that is effective. Is there any way
to query a database and insert that query into a table in access with
out linking or importing the entire table?

Thanks,
Ken
 
Hi, Ken.
Is there any way
to query a database and insert that query into a table in access with
out linking or importing the entire table?
Click to expand...

Create a view in the other database with only the columns and rows you need
for that table, and then link to that view from Access. It will act like a
linked table, even though it's really just a subset of the whole table.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Access Data Projects have a record count limiter-- it might be just what
you're looking for
 
Back
Top