Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter what data is imported by date

Hello all, I have a progress database connected via ODBC. I have a large table called diary with many rows and I want to speed up the time it takes to refresh this table. I have searched high and low...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous ,

    It seems that you want to import the data with date filter to get the most important data rather than all of the data.

    If so, you could enter the SQL Statement to select the data with date condition when you get data via ODBC like below.

    Please refer to this similar thread.

    Best  Regards,

    Cherry

     

     

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous ,

It seems that you want to import the data with date filter to get the most important data rather than all of the data.

If so, you could enter the SQL Statement to select the data with date condition when you get data via ODBC like below.

Please refer to this similar thread.

Best  Regards,

Cherry

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI v-piga-msft thanks for the response. I have zero knowledge of SQL: statements so wouldn't mind some help building what I need. how do I definae the table name, then the row and then specifiy the fact I only want stuff from current month and future dates?

 

thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    don't worry I worked it out. thanks for pointing me in the right direction v-piga-msft