Filter text when exporting from MDB
Thread poster: Vitali Chasnovski

Vitali Chasnovski  Identity Verified
Ukraine
Local time: 12:50
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: 11:50
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: 12:50
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






LSP.expert
You’re a freelance translator? LSP.expert helps you manage your daily translation jobs. It’s easy, fast and secure.

How about you start tracking translation jobs and sending invoices in minutes? You can also manage your clients and generate reports about your business activities. So you always keep a clear view on your planning, AND you get a free 30 day trial period!

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 »



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