Re: VB6 Access97

rotorman wrote:
I have an application written in VB6 which uses an Access97 database,
I retrieve and manipulate the data using ADO and all works very well.
But
I need to save the data in the database files in an external .txt (or
similar) file that can be loaded at a later data. Any help that you
can give will be most welcome.

Several options:
1. Access has builtin functionality to export data to text files. Look in
the Access online help
2. ADO recordsets have a Save method to allow them to be saved to files,
either in binary or xml format
3. You can use VB's builtin file IO capabilities to write data from
recordsets into disk files
4. You can use the FileSystemObject available in the Windows Scripting Host
library to write data to text files

Which option you choose depends on the functionality you need.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • RE: Bind ADO recordset from SQL2K query to recordsource for forms datasheet
    ... where the back-end database is a SQL Server database. ... there are limitations when binding forms to the ADO record. ... Forms Based on ADO Recordsets Are Read-Only ... In Access 2002 and later, to bind a Microsoft Access form to a recordset, you must set the Recordset ...
    (microsoft.public.access.formscoding)
  • Re: Access View
    ... Roland Hall wrote: ... > Can't use CREATE PROCEDURE in Access for the same reason unless you ... but running it via ADO in a VBA module is exactly the same as running ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Closing ADODB sub reference outs in VIs? (LV 8.5.1)
    ... The idea is to call that first to create the Parameters object, ... I've tried using ADO recordsets to insert large datasets, ... Not sure how ADO does this. ... But even if there is no wire comming out of a reference property, ...
    (comp.lang.labview)
  • Re: How to create a checkbox datatype column in a table in VB .net code
    ... Definitely not with ADO, ... but this is a classic ADO newsgroup. ... ADO.Net bears very little resemblance to classic ADO so, ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: ISAM error connecting to MDB and using a linked Sharepoint List
    ... 2007 I can read and write to this Sharepoint List, but when I use ADO ... to connect to the MDB with the OLE Jet provider and read the ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)