beginners help ! using ODBC & limiting the info

[_denis_]

Hi all,

Is there a way when importing a table from a server to only bring in info between a certian date. The hole file is massive & taking ages to bring in.
I'm looking for a filter like MSQUERY in Excel.

Thanks

Denis

 

[Norie]

Denis

Can you not make a link to the table rather than importing it?

Then you could use a query to filter any unwanted data.

 

[_denis_]

Thanks, I'll try that