So I can use a connection string to (using SQL) query an external database and create a recordset (which has to be transposed). Additionally I can use ADOX to create tables and fields in the current project (I need to see all of this in the Access window). What I cannot figure out is how to get that data into the Access object so that I can see it in the window. A sample code of how to do it would be helpful