Hello Dave,
On Fri, 2005-05-06 at 14:12 +0000, david whiting wrote:
> For me just calling mdb-tables with the name of the DB gives me the
> tables. For example:
>
> mdb-tables Nwind.mdb
>
> gives me:
>
> Order Details Orders Products Shippers Categories Customers Employees
> Suppliers
mdb-tables file.pck
ABFBaum AfATabel clItem GEVOBaum sABFKons sBilzTxt sBuchArt sBuchTxt
sEUERTxt sFestKto sMahn sPersKto sSchlBez sStVor sUstVor TBSBaum sFibuK
sSachKto sStTab sZvkK sFKonst Waehrung bFibuHd SendArt
tmpAuktionDocStTmp ABFDruck Inventur SeitInv SeitIPos WEBuch EABPWEBuch
EABPRABuch EABPBuchJournal EABPKtoBlatt tKasBuch tKasSplit
tKasStueckelung sAnlHist sAusw AbgrBuch sAnlagen SAfATab SJAfA AbgrBetr
AbBetr2 IFBProt UserProt sHBank sBankVb sperskom sperskor MahnPositionen
sKzBaum bSalden sKassen ToDo Favoriten sClKonst DOB tSVAssist tKasTrans
sBelArt sGrundl DbProt LastBuH LastBuN sZusatzZeilen ABFMe ABFRabat Tbs
sArtikel ArtLief ArtVerw ArtStat ArtMenge artbeweg StckList ArtPreis
PrsStaff ABFProj Zuschlag ABFDok ABFDokWK ABFPos ABFPosWK ABFTZ ABFPStat
AbfStat RABuch TUBuch ABFStapl RappProj BestDok BestPos BestStat
AcontoBuchung InvFortschritt WebShop WebShopCatalogTreeNew
WebShopCatalogTree tNebenZeileWK sEBImpGrundlagen bEBImport sVorlauf
sBeschr sBuch Elster_Grundl Elster_Main sZKD sInkasso tmpPersKtoSelA
tmpPersKtoSelB TempArtNr sZvkS VZ ZScheck ZDDTA ZASCII VESRDaten ZOnline
TMailAccounts WebShopItems WebShopIDs OrderDoc OrderPos
WebShopBankeinzug ProvData PrsFest sAfterbuyKons ArtAenderCalc
Preisschwellen ProjInf PCFBImport bBuchung bBuchSub bOpoMain bOpoSub
OpProt bPrAntBuch tWKBuch tHauptzeileWK tWKBuchSub TMailDocTypes
TMailDocuments TMailConfig bZList BOPZahl Abgleich Abgl_OP ZAbglDat
BSmlZlg BZahl DlgDaten
So i guess that worked ;)
>
> Can you give the exact error message?
I did a screenshot of the access error message (in german), but i guess
its not intresting anymore at this point.
> And just out of interest are you
> using the C or java version and what is your OS?
I am running Debian sid, with the latest mdb tools (cvs version from
05.05.2005).
Do i now follow your next steps?
ii) mdb-schema -T Orders accessDB mysql
iii) mdb-export to dump the data.
$ mdb-schema -T ABFBaum file.pck mysql
-------------------------------------------------------------
-- MDB Tools - A library for reading MS Access database files
-- Copyright (C) 2000-2004 Brian Bruns
-- Files in libmdb are licensed under LGPL and the utilities under
-- the GPL, see COPYING.LIB and COPYING files respectively.
-- Check out http://mdbtools.sourceforge.net
-------------------------------------------------------------
DROP TABLE ABFBaum;
CREATE TABLE ABFBaum
(
ABFBaumCode varchar (40),
ABFBaumEbene int,
ABFBaumName varchar (31),
ABFBaumDtnrmWrg varchar (23)
);
-- CREATE ANY INDEXES ...
-- CREATE ANY Relationships ...
-- relationships are not supported for mysql
Any idea?
Thanks, Mario
-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games.
Get your fingers limbered up and give it your best shot. 4 great events, 4
opportunities to win big! Highest score wins.NEC IT Guy Games. Play to
win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=20
|
| 
