How to import only a few fields from an external table

[Basalto]

Hi,

There is any option to import only a few selected fields from an
external ODBC table.

The table that I want to import is huge and I need only a subset of
data. I was able to do this in Excel, where I can set the SQL command,
but I can't find a way to do the same in access.

Thanks in advance,

Ricardo

 

[Dennis]

Create a Make Table query with your source table as the ODBC linked table.
You can then select just the fields you want in your query grid.

 

[Klatuu]

Create a View in your SQL database that presents the fields from the table
you want to use. Then just use an ODCB link to the view. Access will see it
just like a table.

 

[Basalto]

I cannot create a view in SQL database because I don't have admin
rights. I'll try the "Make Table" approach but it's not as clean as in
Excel.
Thanks for your reply,
Ricardo

 

[Klatuu]

Well, we do what we have to do. Will the people resonsible for the database
not create it to your specs for you?