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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel to text file problem

Status
Not open for further replies.
badrion

badrion

Programmer
Jul 16, 2001
34
US
I have a program that opens up an excel file and grabs any line that has a "Y" and writes it to a text file. BUT when the user changes the "CUSTNO" to a numeric "12355" it kicks out that line. I have the EXCEL file set to general and I have the VB program set at a Cstr(rs.fields("CUSTNO")) but it is still not reading it as a string. Any suggestions?
 
Status
Not open for further replies.

Similar threads

sal21
  • Question
I can't find the routine to download the image file anymore
Replies
1
Views
126
strongm
strongm
sal21
  • Locked
  • Question
Check of valute change in text file 3
Replies
15
Views
574
strongm
strongm
sal21
  • Question
loopimg link and downlosd zip file 1
Replies
3
Views
197
strongm
strongm
Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
244
Swi
Swi
sal21
  • Locked
  • Question
how to read the coordinates in from this file
Replies
3
Views
423
Ken01
Ken01

Part and Inventory Search

Sponsor

Back
Top