29 Nov 2011 by _Damian S_
If you are going to want your code to control the data conversion, your best bet is to open a dataset for the SQL Server data and process it one row at a time, inserting it into Access. A word of advice though - when you say there is a "lot" of data, by definition anything you do isn't going to...