Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: Programmatically building an MS-Access DB

by periapt (Hermit)
on Feb 23, 2005 at 16:36 UTC ( #433750=note: print w/ replies, xml ) Need Help??


in reply to Programmatically building an MS-Access DB

In the spirit of TIMTOWTDI, you could create a data set in a format that Access reads natively like dBase III. It is a bit more work but you get the added flexibility of having the output in a ubiquitous format that most programs, spreadsheets, databases, word processors and the like, can read easily. Corion has a description of the dBase header format at http://www.corion.net/cgi-bin/wiki.cgi/display/Format:DBase%20III. Once the header is built, the data is just appended sequentially with one byte added at the beginning for a deleted record flag.


PJ
use strict; use warnings; use diagnostics;


Comment on Re: Programmatically building an MS-Access DB
Re^2: Programmatically building an MS-Access DB
by legato (Monk) on Feb 25, 2005 at 14:30 UTC

    That is an interesting thought. I had considered using the CPAN module XBase to generate dbf files, as I've had luck with that before. Unfortunately, the target audience for the delivery of these files is not tech-savvy, nor particularly bright. Think PHB (heh. Nearly typed 'PHP' ;P).

    The number one problem with generating dbf files (which are, incidentally, smaller than mdb) is that the users can't just click to open in thier browser or desktop. Yes, I could just say "open it with Access", but the last time I did something like that (TSV files and Excel) it caused me far too many headaches.

    Thanks for making the suggestion, though, as future querants will probably want to do that instead of bothering with the DAO annoyance I've got now. ++ from me!

    Anima Legato
    .oO all things connect through the motion of the mind

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://433750]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (6)
As of 2014-09-20 13:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (159 votes), past polls