I am trying to pass the OleDbDataReader to table that I can pass out of a function.

I answered myself, if anyone needs

Dim myReader As New DataSet
myAdapt.Fill(myReader)
Return myReader

Just make sure to close the reader before opening any others on the same connection.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.