Re: re[2]: [ACFUG Discuss] excel or csv to database table

2009-03-16 Thread Dusty Hale
t;>> attempt to use CFHTTP with a csv file failed (when a txt worked) because of >>> a likely web server problem? >>> >>> >>> >>> PS Thanks, Shane, for your thoughts on the other thread. >>> >>> >>> >>> /charlie &g

Re: re[2]: [ACFUG Discuss] excel or csv to database table

2009-03-12 Thread Dusty Hale
lie >> >> >> >> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty >> Hale >> *Sent:* Thursday, March 12, 2009 8:56 AM >> *To:* discussion@acfug.org >> *Subject:* Re: re[2]: [ACFUG Discuss] excel or csv to database table >> &g

Re: re[2]: [ACFUG Discuss] excel or csv to database table

2009-03-12 Thread Dusty Hale
orked) because of a likely > web server problem? > > > > PS Thanks, Shane, for your thoughts on the other thread. > > > > /charlie > > > > *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale > *Sent:* Thursday, March 12, 2009 8:56 AM

RE: re[2]: [ACFUG Discuss] excel or csv to database table

2009-03-12 Thread Charlie Arehart
ehalf Of Dusty Hale Sent: Thursday, March 12, 2009 8:56 AM To: discussion@acfug.org Subject: Re: re[2]: [ACFUG Discuss] excel or csv to database table Hi Charlie and many thanks for the good advice. I got curious about running real queries on text files. I have done this some years ago using a D

Re: re[2]: [ACFUG Discuss] excel or csv to database table

2009-03-12 Thread Dusty Hale
t; *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale > *Sent:* Monday, March 09, 2009 3:15 PM > *To:* discussion@acfug.org > *Subject:* Re: re[2]: [ACFUG Discuss] excel or csv to database table > > > > Thanks again. I tried the approach below which was r

RE: re[2]: [ACFUG Discuss] excel or csv to database table

2009-03-09 Thread Charlie Arehart
ilable for as little time as may be needed to solve a problem. More at carehart.org/consulting/. From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Dusty Hale Sent: Monday, March 09, 2009 3:15 PM To: discussion@acfug.org Subject: Re: re[2]: [ACFUG Discuss] excel or csv to database table T

Re: re[2]: [ACFUG Discuss] excel or csv to database table

2009-03-09 Thread Dusty Hale
Thanks again. I tried the approach below which was recommended on cf411.com. It works as long as the file extension is .txt. When using the .csv extension, it throws an error "Variable onerow does not exist". I am fine with just using the .txt extention but if anyone has any clue why or how I coul