Hi, Chris.
Does anyone know of a web based tool to convert Access 97 databases into
Access 2000 format ?
The Access 97 and 2000 file formats are undocumented, proprietary file formats,
so such a tool would cost about $20,000 to $30,000 to develop. It's doubtful
anyone would invest in building such an expensive tool when Access 2000 and
newer can convert the Access 97 files wholesale at a cost of one license for
Access 2000 or newer.
I have an application which extracts the data under
Unix, but it doesn't work correctly with Access 97 files.. hence I need to
convert them to Access 2000.. (the application uses mdbtools to extract the
data, but it has some weird bugs that affect Access 97 files)
They did a great job with the undocumented file formats, but they had to make a
lot of guesses, some of which are wrong. Hence, the bugs in any tool which
relies on those incorrect guesses.
the application in question will be processing several hundred
files a day, pulling them straight from an FTP server..
No. It won't for the Access 97 files -- unless you overcome a huge show
stopper. If all you need is the data, then you don't even need Microsoft Access
or MDBTools. The easiest, cheapest way is to network a Windows 2000 or newer
computer to the Unix/Linux box (I'm assuming that's what your FTP server is from
your requirement that the application must run on Unix/Linux), then create a VB
Script and run it on the Windows computer to extract the table data into a text
file you can import into any database. (Or you can modify the following example
to import directly from the Access 97 table into the database of your choice
instead of a text file.) I'd recommend modifying this script so that it loops
through the file names in the directory and loops through the tables in each
file, but this example will get you started.
Example VB Script:
' * * * * Begin code * * * *
Dim cnxn
Dim sDBPath
Dim sTextFile
Dim sDBTable
sDBPath = "T:\Unix\MDBs\MyDB.mdb"
sTextFile = "[TEXT;HDR=YES;DATABASE=T:\Unix\Data\].DBName_TableName.txt"
sDBTable = "[;DATABASE=T:\Unix\MDBs\MyDB.mdb;].TableName"
Set cnxn = CreateObject("ADODB.Connection")
cnxn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
sDBPath & ";Persist Security Info=False"
cnxn.Execute "SELECT * INTO " & sTextFile & _
" FROM " & sDBTable
cnxn.Close
Set cnxn = Nothing
' * * * * End code * * * *
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
Skeleton Man said:
Hi,
Does anyone know of a web based tool to convert Access 97 databases into
Access 2000 format ? I have an application which extracts the data under
Unix, but it doesn't work correctly with Access 97 files.. hence I need to
convert them to Access 2000.. (the application uses mdbtools to extract the
data, but it has some weird bugs that affect Access 97 files)
Any solution that's either web based or will run under unix/linux is
welcome.. the application in question will be processing several hundred
files a day, pulling them straight from an FTP server.. so downloading to
my PC and converting with MS Access is not an option..
Regards,
Chris
