Export Microsoft Access Database to Text File

[cass84]

Hi, I'm using Visual Basic Express 2008 (VB.NEt). I've created a project which
connect to a Microsoft Access Database (OLEDB) & displays the records using textboxes in the windows app.

I need to add a button which exports the database to a fixed length text file. Does anyone know the code I would use to do this?

 

[MattP]

Since you've already got a DataTable I'd use a For Each loop and iterate over each DataRow in you DataTable.Rows. For each row I'd use an IO.StreamWriter to write out your fixed length line.

 

[cass84]

Ok so what would be the code for such a thing?