Generating new file from mdb database in VB

[Elliina]

Hi

Any tips for generating a new prd-file (own file type) from a mdb database (Access)? prd- file consists of variables and check-sums that are separated by ASCII 32 and ASCII 10.

I know how to make a mdb database from a prd-file, but is there any (easy) way to do this?

Thanx,
Elliina (by the way, She ;-))

[Clunietp]

Can you create this file by exporting tables from MS Access? If so, try these steps, they have always worked for me:

1) create a macro in access that does what you want it to

2) convert macro to visual basic (command in Access)

3) copy vba code to visual basic

4) add reference to Access x.0 object library (whatever version, must be 8 (97) or higher i believe)

5) create object in code and use the VBA you copied from step 3

HTH

Tom

[Elliina]

Well, I'd better try this one. Any other ideas?

~Elliina~

[Clunietp]

what is ascii 32 and ascii 10?

[Elliina]

ASCII 32 = space bar
ASCII 10 = linefeed

~Elliina