failed getting rowset(s) from current datasource

[popodc]

Hello guys. when im trying to view the datareport with my excel as my data source it has an error ("failed getting rowset(s) from current datasource").. will someone give me a code on how to import an excel file and view its columns or rows on a datareport. thanks guys :wave:

[d3gerald]

maybe this could help

http://vbforums.com/showthread.php?t=394651

just open a recordset getting the data from your excel file and from that recordset, pass those values to your report

[popodc]

cannot run ur sample application.. it needs ADOX or something.. cannot find project or library. where can i download such? thanks