I need to connect to 2 different odbc databases and transfer data between the two. One will be a flat text file the other ms-access. Is there a way to use a select statement possibly? Or any type of tool to do so. Basically I will just be inserting a bunch of rows from the flat database into msaccess.