Generate DataTables Dynamically

Question

Hi
I have an access db and I want to be able to generate dataTables dynam. with only one dataAdapter?

So far every time I build the query string (ie. "select * from foo;select * from foo2;") i get an
error when i execute the c# console app. "Error: Characters found after end of SQL statement."

thanks for the help