• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 313
  • Last Modified:

Export from mdb to txt

I need to export multiple records from the database to a text file but the problem is that I need to have all the records printed on one line and not each on a single line.

Do While Not rst1.EOF
Print #sessfile, Format(Str(rst1!number), "000000")  ' & "000000" & invoice & "    "
 rst1.MoveNext
   Loop
In this case, each record is printed on a single line, but I need to have all the records on one line. (without CR or enter)
thank you
0
houssam_ballout
Asked:
houssam_ballout
  • 2
1 Solution
 
jtdebeerCommented:
simply do a Replace(strname,vbcrlf,' ') on the exported string
0
 
VBClassicGuyCommented:
Or just place a seimcolon at the end of each Print # statement.
0
 
houssam_balloutAuthor Commented:
This code will produce a carriage return (line feed), but I want all the records to be on one line. So when printing other records they will be next to the previous one and not on a new line.
 
0
 
houssam_balloutAuthor Commented:
The semi colon worked
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now