Hacker News new | ask | show | jobs
by zubairq 900 days ago
Brings back memories of a similar task I have with importing MS Access files (the MS Access file format is undocumented).

I am trying to parse the MS Access files using NodeJS/Javascript. I last tried about 3 years ago and it was really tough going, so there is a lot of trial and error. I am able to parse some basic MS Access files, but need to figure out a way to get the whole database more reliably. My effort was here:

https://github.com/yazz/noaccess

1 comments

oh god, that sounds like a painful thing to try to do. there's an Access redistributable at https://www.microsoft.com/en-us/download/details.aspx?id=549...

i've never attempted JS interop, so i don't know how much it sucks, but it definitely seems doable. it'll likely be an adventure on it's own, but it's gotta be 1000x less fuckery than trying to reverse the binary format of Access

the saner option would probably just be a small .Net program that creates an endpoint for your JS

unless i'm assuming too much, and you're just doing it for sheer masochistic pleasure, and in that case: i salute you

Yes, it is extremely painful. Thanks for the link, that may come in useful. But in general, the reason that I didn't use the Access redistributable is because I am building a Low Code system that I want to be able to import the Access database files that can work on Linux, Windows, or Mac.
I remember taking a look at mdbtools and not using it... can't remember why now, but I'll take another look. Thanks!