Are Access and Excel File Definitions Available

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I currenlty do most of my processing in SAS and
frequently convert files to either .mdb or .xls using
SAS's export functions. However, there are some problems
with the export functions.
In the past, I've had layouts of .dbf and have built the
files directly from SAS. Was wondering if anyone has
the .mdb and .xls file layouts so that I can build these
files directly from SAS also. Thanks.
 
Was wondering if anyone has
the .mdb and .xls file layouts so that I can build these
files directly from SAS also.
Click to expand...

No. These are Microsoft trade secrets and are not publicly documented.

For Access in particular, the mapping between SAS and relational
tables is at best a rather remote and tenuous one!
 
Dan said:
I currenlty do most of my processing in SAS and
frequently convert files to either .mdb or .xls using
SAS's export functions. However, there are some problems
with the export functions.
In the past, I've had layouts of .dbf and have built the
files directly from SAS. Was wondering if anyone has
the .mdb and .xls file layouts so that I can build these
files directly from SAS also.
Click to expand...

You can read data from MDB files using the MDB Tools library. MDB
Tools is a set of libraries and utilities to facilitate exporting data
from MS Access databases (mdb files) without using the Microsoft DLLs.
In other words they are reverse engineering the layout of the MDB
file.http://mdbtools.sourceforge.net/

Those folks may be working on updating/inserting records but that
would be a lot more complex than reading records.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top