I am not (currently) using dts to import this. That is the only place (well and in access) I have even ever noticed it. How do the column names help me?
Timothy Heald ACP/CCFD :) 910-425-9988 Manager Fayetteville ColdFusion User Group http://www.fcfug.org Fusebox Advisory Committee Member http://www.fusebox.org -----Original Message----- From: Nick McClure [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 12:33 AM To: CF-Community Subject: RE: Tab Delimited file question You need to use the first row as the column headings. That will help you some. At 12:15 AM 8/15/2002 -0400, you wrote: >Well that got us closer to the answer. There are supposed to be 55 columns. >I get 46 or 48 after the replace. Suggestions? > >Is there a way to get excel to list numbers as column headers instead of >letters? > >Timothy Heald >ACP/CCFD :) >910-425-9988 > >Manager Fayetteville ColdFusion User Group >http://www.fcfug.org > >Fusebox Advisory Committee Member >http://www.fusebox.org > > >-----Original Message----- >From: Timothy Heald [mailto:[EMAIL PROTECTED]] >Sent: Thursday, August 15, 2002 12:11 AM >To: CF-Community >Subject: Tab Delimited file question > > >Hey, > Ok so I am looping through this tab delimited file to write it in a SQL >DB. Rows are no problem. Problem is in the columns. There are many empty >columns, and as such two tabs right next to each other. So my lengths come >out all wring, and when I try and use list functions I exceed the index. > > Ideally I would like to use listToArray, and just be able to call the >values that way. Nice, easy, logical. Any suggestions? hmm guess I could >do a replace() all #chr(9)##chr(9)# with #chr(9)# #chr(9)# or some such. >Off to try it :) > >Timothy Heald >ACP/CCFD :) >910-425-9988 > >Manager Fayetteville ColdFusion User Group >http://www.fcfug.org > >Fusebox Advisory Committee Member >http://www.fusebox.org > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
