SteveClarkson
Registered User.
- Local time
- Today, 09:50
- Joined
- Feb 1, 2003
- Messages
- 439
Hello,
I have a DB which contains about 110 tables, all have the same fields in (I know, poor design, it is an export from some dodgy 3rd party bit of software).
Anyway - I would like to export them all to either seperate spreadsheets, or a single spreadsheet, either as seperate sheets, or all in one.
I'm really not very bothered HOW it get it out... I just need to get it out!
I would imagine it is a time for a loop in vba, but I'm afraid my knowledge of things is limited at best!
Any help would be much appreciated!
I have a DB which contains about 110 tables, all have the same fields in (I know, poor design, it is an export from some dodgy 3rd party bit of software).
Anyway - I would like to export them all to either seperate spreadsheets, or a single spreadsheet, either as seperate sheets, or all in one.
I'm really not very bothered HOW it get it out... I just need to get it out!
I would imagine it is a time for a loop in vba, but I'm afraid my knowledge of things is limited at best!
Any help would be much appreciated!