Converting MS Access mdb file

[maxtektips6]

Hi,

Is there any way to convert an MS Access file before doing some processing on a Unix system ? Tried using strings but some information gets lost, particularly dates.

Thanks for help

 

[KenCunningham]

Not sure I understand, but perhaps export your data from Access into (say) csv format and work on it through that?

I want to be good, is that not enough?

 

[MadMichael]

Use the MSACCESS 'Export' function to create a '.txt' file from your database. The wizard allows you to choose fixed-width or delimited output.

 

[maxtektips6]

Avoiding using windows alltogether is the goal (sounds familiar?). The idea is to have a script on the unix machine to download the mdb file from the internet then process it. Currently the preliminary export to txt on windows is an overhead and requires a manual intervention.

 

[Annihilannic]

Maybe this will help?

http://mdbtools.sourceforge.net/

Annihilannic.

 

[maxtektips6]

Thanks Annihilannic, it looks like this could the thing.
Meanwhile i've managed to convince the source of the file to opt for another format.