Filter text when exporting from MDB
Thread poster: Vitali Chasnovski

Vitali Chasnovski  Identity Verified
Local time: 15:18
Member (2005)
German to Russian
+ ...
Aug 16, 2006

Hi all,
I am not very good in SQL-language and have some problem in writing of filtering scripts.
To export from MDB I need to filter translations in Subject AND time period (DateStamp from - to).
What text may I write?
Thanks in advance.


Terry Richards
Local time: 14:18
French to English
+ ...
An easier way Aug 16, 2006

If this is an MDB, the easiest way is to create a query in Access and then export that query. To export a query, select it in the Access main window and then choose File | Export.

If you realy want to do it in SQL, you will need something like this:

SELECT Field1, Field2...
FROM Table
WHERE DateField > #12/1/2006# AND DateField < #1/1/2007# AND Subject = 'Whatever';

Note that the dates should be in US format (m/d/y) and surrounded by #'s regardless of your local settings.



Vitali Chasnovski  Identity Verified
Local time: 15:18
Member (2005)
German to Russian
+ ...
export to Trados Aug 16, 2006

Yes, it works.
I have exported MDB records to Trados Workbench using this filter:

DateStamp >= #04/04/2001# AND DateStamp < #04/30/2001# AND Subject = '537'

Thank You very much, Terry.


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Pavel Tsvetkov[Call to this topic]

You can also contact site staff by submitting a support request »

Filter text when exporting from MDB

Advanced search

Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »
SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search