Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

DarkBASIC Professional Discussion / Data Format

Author
Message
Codger
23
Years of Service
User Offline
Joined: 23rd Nov 2002
Location:
Posted: 26th May 2003 08:57
Link
Does anyone know the format of the data when using the Standard DBPro file commands "OPEN to Write" etc.
I have a project that will read data statements write them to a file and read them back, but when I try to use "MS ACCESS" or "EXCEL" to manipulate a large amount of data I cannot read the file created by DBPro


All help Appreciated
Back to top
Profile PM Email
ozak
23
Years of Service
User Offline
Joined: 22nd May 2003
Location: Denmark
Posted: 26th May 2003 09:57
Link
You need to make sure it's in a format Access or Excel knows.
You can't just produce a binary or text file and hope it works.
You probably want to make it a text file, comma (,) seperate the data and import it as a CSV file into Access or Excel.

Woah. 3 lines starting with You! Beat that

Back to top
Profile PM
The admiral
23
Years of Service
User Offline
Joined: 29th Aug 2002
Location:
Posted: 26th May 2003 11:09
Link
Open it in word not ms access or excel. It works in word I know ive used it or you could use notepad.

[href]www.vapournet.com/~flyer[/href]
Back to top
Profile PM Email Website
Shadow Robert
23
Years of Service
User Offline
Joined: 22nd Sep 2002
Location: Hertfordshire, England
Posted: 26th May 2003 15:34
Link
if you want to create and ms access or excel document you have to structure the data in those formats.

you'll find the formats on http://www.wotsit.org

Within the Epic battle of the fates the Shadow and the Angel will meet. With it will harbinger the very fight of good vs evil!
Back to top
Profile PM Email Website
IanM
Retired Moderator
23
Years of Service
User Offline
Joined: 11th Sep 2002
Location: In my moon base
Posted: 27th May 2003 02:06
Link
... until the next release of the office tools, when MS will make them completely different
Back to top
Profile PM Email Website
Shadow Robert
23
Years of Service
User Offline
Joined: 22nd Sep 2002
Location: Hertfordshire, England
Posted: 27th May 2003 04:44
Link
yeah but it'll always load and save legacy formats gotta love MSOffice for that

Within the Epic battle of the fates the Shadow and the Angel will meet. With it will harbinger the very fight of good vs evil!
Back to top
Profile PM Email Website
Codger
23
Years of Service
User Offline
Joined: 23rd Nov 2002
Location:
Posted: 27th May 2003 09:17
Link
Thanks for the help but..
The problem I'm having is that when DBP sends a write command it adds a carriage return (for those coming from the original basics this is a writeln).
This means that each section of the file is treated like a record making it difficult to manipulate in any database.
The other issue is that the numeric fields are saved in what appears to be a form of binary code making further external manipulation difficult.

The idea behind the project is to give a group of models certain characteristics (strength, speed, amour intelligence etc.) they would then be allowed to compete in an arena with no external "human influence" to determine the "survival of the fittest" I need to allow others to input their characteristics separate from the program, data statements are fine for development but too restrictive and need permission to manipulate the code file

ah well we will get there in the end

Back to top
Profile PM Email
Back to top

Login to post a reply

Server time is: 2026-07-11 04:23:56
Your offset time is: 2026-07-11 04:23:56