|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
July 18th, 2003, 01:51 PM
|
|||
|
|||
|
Creating a delimited text file
It's me, the noob, again. My project is going well, but now I'm into the thick of it.
I need to create a delimited .txt file using information from an access database. I have been using DAO thus far. I am having trouble finding any documentation that tells me how to pull an individual field from a record and write it to file. Any help/advice would be greatly appreciated (once again). thanks, Jason
|
|
#2
July 18th, 2003, 02:47 PM
|
|||
|
|||
|
i assume you know how to get one field from the database.
writing to a file isn't hard in vb6: Code:
' open file for write
Open FilePathAndName For Output As #1
' loop through rows
Write #1, rs.Fields.Item("SomeField").Value
' end loop
Close #1
i'm sure you should be able to find lots of source code on how to write to files in vb6.
__________________
Programmer's Corner
|
|
#3
July 18th, 2003, 02:50 PM
|
|||
|
|||
|
actually, that's the one thing i was having a hard time finding. How to actually pull the one field out of the db. heh, just unlucky google searches, I guess. Thanks a lot.
jason
|
|
#4
July 18th, 2003, 02:55 PM
|
|||
|
|||
|
do you know any sql? it's about the only way you could only select on field from a table.
Code:
SELECT SomeField FROM SomeTable
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Creating a delimited text file |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
