Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > .NET General

Vista - Export Microsoft Access Database to Text File

Reply
 
Old 08-07-2009   #1 (permalink)
Cass


 
 

Export Microsoft Access Database to Text File

Hi, I'm using Visual Basic Express 2008. I've created a project which
connect to a Microsoft Access Database & displays the records in the
app with the Default Navigation.

I need to add a button which exports the database to a fixed length
text file. Does anyone have the code for this?

So far this is the forms code:

Public Class Customers

Private Sub CustdataBindingNavigatorSaveItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
CustdataBindingNavigatorSaveItem.Click
Me.Validate()
Me.CustdataBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.CustdbDataSet)

End Sub

Private Sub Customers_Load(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the
'CustdbDataSet.custdata' table. You can move, or remove it, as needed.
Me.CustdataTableAdapter.Fill(Me.CustdbDataSet.custdata)

End Sub
End Class

When I look at the app.config file it says I am using a OLEDB:
<connectionStrings>
<add name="Custs.My.MySettings.custdbConnectionString"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=|DataDirectory|\custdb.mdb"
providerName="System.Data.OleDb" />
</connectionStrings>

Thanks in advance for the help!

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Export SQL Server table to text file VB Script
Importing text file to Access Database VB Script
How to export Visio shapes and text to txt or excel file? .NET General
Export WLM messages to text file Live Mail
comma delimited text file into database PowerShell


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46