Convert table information to binary

[bcooler]

Hello and thanks for reading!

I was asked to create a database to contain a library of information coming out of a piece of equipment we use. I worked on that a while and have it importing the .CSV file that is produced by the equipment. No problem....

Now I am asked to push some portion of this information (that may be modified via the database) back into the equipment via a binary file (let's call the file name Library.lb2).

I have been given the "mapping" scheme such that the first 4 bytes of the binary file should be a library version, the second 4 bytes is the Record version, and so on.

To accomplish this, I imagine I need to obtain the first info from a table, convert to binary, store as a variable, and then append the next part of information to it and so on. Once I'm complete, I would need to save this variable "string" to a file called "library.lb2" as binary (not actual ASCII text with 1's and 0's, but binary 1's and 0's). While I'm off trying to discover how to do this, I thought I would ask if anyone has ideas on the simplest approach.

Thanks!
Brian

 

[bcooler]

ok, I found this, but not sure if it will be useful...

[URL unfurl="true"]http://support.microsoft.com/kb/151335[/url]

The first thing I notice is I must have fixed byte lengths for each component, not variable as shown in the example.