I want to generate a report on access using vb is this possible. I found some SQL that said i can dump data into an excel file using insert into. Ant thoughs on the best approach,