Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

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 Once the header is built, the data is just appended sequentially with one byte added at the beginning for a deleted record flag.

use strict; use warnings; use diagnostics;
  • Comment on Re: Programmatically building an MS-Access DB

Replies are listed 'Best First'.
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?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://433750]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (4)
As of 2018-01-24 04:19 GMT
Find Nodes?
    Voting Booth?
    How did you see in the new year?

    Results (255 votes). Check out past polls.