Exporting a database
Posted on 1998-08-23
I want to export a database file to some other formats.
I have no real idea if this is easy or hard, but it must
be done from within VB (VB 5 Pro), using only what comes with VB (ie: no extra controls, or 'user must have xxx installed on their system).
Let's assume I have a database file called main.mdb (Access)
Then I have 4 tables : table1, table2, table3, table4
How would I export the information in these tables, to
1 - ASCII
2 - Excel
3 - Any spreadsheet (same stuff as Excel?, perhaps a Comma separated field?)
My program simply uses the Data control to add, view, delete, and update my database...and I want an option to export the contents to those formats.
Thanks for any help,
(ps: I will give bonus points for a great answer)