Printable View
Hey all, I've got a question concerning the construction of a database... The problem lies in how my data is formatted. It's a .txt file that is divided as shown:
Field1: ~~~~
Field2: ~~~~
Field3: ~~~~
~~~~~~~~
~~~~~~~~
Field4: ~~~~
Record by record, each record being seperated by a blank line... My initial guess was that I needed a text parser to break the information down, but I was lost there...
Any direction for a new kid?
what language are you trying to do this in?
I'm guesssing the finished database will be in access (althought it could certainly be anything). I'm just trying to use what I've already got... The program that will be reading the database will be HPC 2000 (so I'll be using eVB 3). Does that help?
anybody else care to weight in on this?
If it runs a Windows OS, I would use .Net. My IPAC had a version of Windows on it.
I'm not sure about HPC, but PPC supports Access databases (only data, no screens etc), which can be used from eVB.
Once the data is in Access you can use ActiveSync to copy it across to your device, I would recommend doing this with a test database before you try converting your data.
In terms of getting the data converted, what desktop programming languages do you have? (if none, have you got Office?). Also, how much data is there?
I don't have any other programming experience except for w/ eVB... however, I do have office and Access. I wasn't having an luck with it though, because Access wanted to treat the information as an Excel table...
What am I doing wrong here?
At the moment your data is not in a database style, so however you are going to use it, it needs to be converted. There's no problem with the tools you've got, VBA (which is included in the Office apps) is very similar to eVB, so you can use that to convert the data (and we can help if needed).
First things first though, make a simple test database and try to copy it across to the device - we need to verify that you can actually use Access databases. If that works, the next step is to try to interface with it - I'll post an eVB project to test it later.