Export all tables in a single operation?

  • Thread starter Thread starter harry
  • Start date Start date
H

harry

Just installed Office XP (sp2) & because my employer still uses Office 97 I
need a way of transfering an Access XP database to Access 97. So I thought
simple! just export to text file, excel, etc... then import from Access 97.

The problem is I can't seem to find a way of exporting all the tables in one
go - some of the databases will have loads of tables in & exporting them
individually will take me ages - surely this is possible? - or will I have
to uninstall & back to 97?

thanks

harry
 
Simplest approach:
Tools | Database Utilities | Convert Database | To Access 97 format

If you needed to do it in code, you could loop through the TableDefs
collection, skipping the hidden system tables (begin with (MSys") and temp
tables (begin with "~").

Alternatively:
SELECT MsysObjects.Name FROM MsysObjects
WHERE (([Type] = 1) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY MsysObjects.Name;
 
excellent! many thanks for that!

Allen Browne said:
Simplest approach:
Tools | Database Utilities | Convert Database | To Access 97 format

If you needed to do it in code, you could loop through the TableDefs
collection, skipping the hidden system tables (begin with (MSys") and temp
tables (begin with "~").

Alternatively:
SELECT MsysObjects.Name FROM MsysObjects
WHERE (([Type] = 1) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY MsysObjects.Name;

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

harry said:
Just installed Office XP (sp2) & because my employer still uses Office
Click to expand...
97
I
need a way of transfering an Access XP database to Access 97. So I thought
simple! just export to text file, excel, etc... then import from Access 97.

The problem is I can't seem to find a way of exporting all the tables in one
go - some of the databases will have loads of tables in & exporting them
individually will take me ages - surely this is possible? - or will I have
to uninstall & back to 97?
Click to expand...
Click to expand...
 
Back
Top