reading tables in VB

[Guest]

I need to access a table from VB so I get at the different records and
eventually write them out to a file in a format that i have designed. But
can't figure out how to get at the talbe.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ExportFormattedFixed.mdb" which illustrates how to do this.
Look in the module ExportFile for code. The formatting for the fields is
done it the query: qryExportFormatted.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Adam Turner via AccessMonster.com]

I need to access a table from VB so I get at the different records and
eventually write them out to a file in a format that i have designed. But
can't figure out how to get at the talbe.

Tools >> References >> Microsoft ADO Ext. 2.8 for DDL and Security >> Check
it

Dim rs1 As ADODB.Recordset
Set rs1 = New ADODB.Recordset

MyLocation = App.Path + "\BatchArchive\" + txtBatchID.Text + ".mdb"

rs1.Open "SELECT * FROM " & MyTable, "Provider='Microsoft.Jet.OLEDB.4.0';" &
"Data Source=" + MyLocation, adOpenStatic, adLockOptimistic

rs1.movefirst

Do Until rs1.EOF
This is the playground
rs1.MoveNext
Loop