Mobile menu

Filter text when exporting from MDB
Thread poster: Vitali Chasnovski

Vitali Chasnovski  Identity Verified
Ukraine
Local time: 10:25
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.


Direct link Reply with quote
 
Terry Richards
France
Local time: 09:25
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.

T.


Direct link Reply with quote
 

Vitali Chasnovski  Identity Verified
Ukraine
Local time: 10:25
Member (2005)
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.


Direct link Reply with quote
 


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






Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs