Solved

Access 97: Export table to TAB delimited file

Posted on 2010-09-10
3
376 Views
Last Modified: 2013-11-28
I have a table with these fields:
email, payment_amount, currency

I need to output each record into a TAB delimited TEXT file. It seems Access97 only outputs into a Comma delimited text file.

I am sure this is easy to do...I am busy with other coding!

VB code please.

High points for a speedy solution!
:)
0
Comment
Question by:SOTA
3 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 400 total points
ID: 33646479
path - is file name with path, tblname - source table name
Function TextStreamTest(path As String, tblname As String)
    Dim dbs As Database
    Dim TXT As String
    Dim rst As Recordset, l As Long
    Set dbs = CurrentDb
    Set rst = dbs.OpenRecordset(tblname)
    Open path For Output As #1
    l = rst.RecordCount
    Do While l > 0
        TXT = rst![Field1] & chr(8) & rst![Field2] & chr(8) & rst![Field3]
        Print #1, TXT
        l = l - 1
        rst.MoveNext
    Loop
    rst.Close
    Close #1
End Function
0
 
LVL 92

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 100 total points
ID: 33646485
SOTA,

Have you tried creating a specification that declares the tab as the delimiter?

Patrick
0
 

Author Closing Comment

by:SOTA
ID: 33649515
Sweet!
Thanks for the 2 comments!!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question