Hi All,
I have not used Access before.
I have an access mdb database file which contains many tables.
I have it stored as "C:\DS\SQLDataFundamentals.mdb"
I would like to extract all tables from this mdb file and store them in the same folder (i.e. ""C:\DS\") as a CSV file and also an Excel 95 file with the same name as the table
e.g. If a table in "SQLDataFundamentals.mdb" is called "DUAL", I would like to export this to both "C:\DS\DUAL.csv" and "C:\DS\DUAL.xls")
Could anyone please show me some code that i could run to allow this to happen?
Any help appreciated.
kind regards
