https://www.proz.com/forum/d%C3%A9j%C3%A0_vu_support/53408-filter_text_when_exporting_from_mdb.html
This site uses cookies. Some of these cookies are essential to the operation of the site, while others help to improve your experience by providing insights into how the site is being used. For more information, please see the ProZ.com privacy policy.
Cookie settings

Technical forums » Déjà Vu support »
Filter text when exporting from MDB
Thread poster: Vitali Chasnovski
Vitali Chasnovski
Vitali Chasnovski  Identity Verified
Ukraine
Local time: 14:19
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
Terry Richards
France
Local time: 13:19
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 regardl... See more
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.

T. ▲ Collapse
 
Vitali Chasnovski
Vitali Chasnovski  Identity Verified
Ukraine
Local time: 14:19
German to Russian
+ ...
TOPIC STARTER
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


Forum rules
Help and orientation




Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »
TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »