I am writing code to select data from sql database to put into an access database. I know I can create two datasets and read from sql and write to access. Is there a way to call a the export wizzard from enterpise manager from vb? Is my first method best way to do this? there are 18k records and it will continue to grow monthly. I need to make sure it will run quickly.
Thanks for your opinion and help.