Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing access data to txtfiles
- Thread starter SpeakUp
- Start date
Using recordsets, and print#, you can scroll through the tables and write the records to a file.
you would create the recordset, open a file, and use something like:
rs.movefirst
do while not rs.eof and rs.bof
print# rs.field1 & "," & rs.field2....., hndOutputFile
rs.movenext
loop
Something like that should get you going.....
you would create the recordset, open a file, and use something like:
rs.movefirst
do while not rs.eof and rs.bof
print# rs.field1 & "," & rs.field2....., hndOutputFile
rs.movenext
loop
Something like that should get you going.....
- Status
