Importing access data from an OBDC data source

[Guest]

I need to import data from an OBDC data source. The table from which the
data is taken is very large (many columns). The import fails because the
record is to big. How can I restrict the import to the columns that I need?

 

[Guest]

Try using a SQL statement to limit the amount of data being queried into the
recordset (example SELECT columnlist
FROM tablename
[WHERE condition(s)];
w3schools.com may have a list of SQL statements